ByteScout Barcode Suite – C# – Copy range with spreadsheet sdk

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

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

How to copy range with spreadsheet sdk in C# using ByteScout Barcode Suite

Learn to copy range with spreadsheet sdk in C#

These sample source codes on this page below are displaying how to copy range with spreadsheet sdk in C#. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK and you can use it to copy range with spreadsheet sdk with C#.

Want to save time? You will save a lot of time on writing and testing code as you may just take the C# code from ByteScout Barcode Suite for copy range with spreadsheet sdk below and use it in your application. Simply copy and paste in your C# project or application you and then run your app! Want to see how it works with your data then code testing will allow the function to be tested and work properly.

ByteScout Barcode Suite free trial version is available on our website. C# and other programming languages are supported.

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");
        }
    }
}