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

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

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

How to copy range with spreadsheet sdk in C# and ByteScout Data Extraction Suite

Learn to code in C# to copy range with spreadsheet sdk with this step-by-step tutorial

ByteScout simple and easy to understand tutorials are planned to describe the code for both C# beginners and advanced programmers. ByteScout Data Extraction Suite can copy range with spreadsheet sdk. It can be applied from C#. 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.

The following code snippet for ByteScout Data Extraction Suite works best when you need to quickly copy range with spreadsheet sdk in your C# application. Simply copy and paste in your C# project or application you and then run your app! Enjoy writing a code with ready-to-use sample codes in C#.

You can download free trial version of ByteScout Data Extraction Suite from our website to see and try many others source code samples for C#.

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.Diagnostics;
using System.IO;
using Bytescout.Spreadsheet;

namespace CopyRange
{
    class Program
    {
        static void Main(string[] args)
        {
            // Open spreadsheet from file
            Spreadsheet document = new Spreadsheet();
            document.LoadFromFile("example.xls");

            // Get first worksheet
            Worksheet worksheet = document.Workbook.Worksheets[0];

            // Select cell range
            Range range = worksheet.Range("A2:B8");

            // Copy range to C10 cell
            range.CopyInto("C10");

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

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

            // Close spreadsheet
            document.Close();

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