ByteScout Barcode Suite – C# – Select active worksheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Select active worksheet with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Select-active-worksheet-with-spreadsheet-sdk.pdf

How to select active worksheet with spreadsheet sdk in C# and ByteScout Barcode Suite

Step-by-step tutorial on how to select active worksheet with spreadsheet sdk in C#

Quickly learn how to select active worksheet with spreadsheet sdk in C# with this sample source code. Want to select active worksheet with spreadsheet sdk in your C# app? ByteScout Barcode Suite is designed for it. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK).

The following code snippet for ByteScout Barcode Suite works best when you need to quickly select active worksheet with spreadsheet sdk in your C# application. This C# sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Complete and detailed tutorials and documentation are available along with installed ByteScout Barcode Suite if you’d like to learn more about the topic and the details of the API.

ByteScout provides the free trial version of ByteScout Barcode Suite along with the documentation and source code samples.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.Spreadsheet;
using Bytescout.Spreadsheet.Constants;
using System.Diagnostics;
using System.IO;


namespace HelloWorld
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();

            // Add new worksheets
            Worksheet worksheet1 = document.Workbook.Worksheets.Add("Worksheet1");
            Worksheet worksheet2 = document.Workbook.Worksheets.Add("Worksheet2");
            Worksheet worksheet3 = document.Workbook.Worksheets.Add("Worksheet3");

            // Activate worksheet2
            worksheet2.Active = true;

            // delete output file if exists already
            if (File.Exists("Output.xls")){
                File.Delete("Output.xls");
            }

            // Save document
            document.SaveAs("Output.xls");

            // Close Spreadsheet
            document.Close();

            // open generated XLS document in default program
            Process.Start("Output.xls");
        }
    }
}