ByteScout Data Extraction Suite – C# – Copy worksheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Copy worksheet with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Copy-worksheet-with-spreadsheet-sdk.pdf

How to copy worksheet with spreadsheet sdk in C# using ByteScout Data Extraction Suite

How to write a robust code in C# to copy worksheet with spreadsheet sdk with this step-by-step tutorial

The sample shows instructions and algorithm of how to copy worksheet with spreadsheet sdk and how to make it run in your C# application. ByteScout Data Extraction Suite is the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can be applied to copy worksheet with spreadsheet sdk using C#.

Want to quickly learn? This fast application programming interfaces of ByteScout Data Extraction Suite for C# plus the guidelines and the code below will help you quickly learn how to copy worksheet with spreadsheet sdk. Follow the instructions from scratch to work and copy the C# code. Want to see how it works with your data then code testing will allow the function to be tested and work properly.

Our website gives trial version of ByteScout Data Extraction Suite for free. It also includes 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 System.Diagnostics;
using System.IO;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            // Open existing Spreadsheet
            Spreadsheet document = new Spreadsheet();
	document.LoadFromFile("input.xls");

            // Create copy of worksheet
            document.Workbook.Worksheets.Copy(0, 1, "Copy of Sheet1");

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

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

            // Close document
            document.Close();

            // Open document in default xls viewer
            Process.Start("Output.xls");
        }
    }
}