ByteScout Data Extraction Suite – C# – Copypaste rows with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Copypaste rows with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Copypaste-rows-with-spreadsheet-sdk.pdf

How to copypaste rows with spreadsheet sdk in C# and ByteScout Data Extraction Suite

Step-by-step tutorial on how to copypaste rows with spreadsheet sdk in C#

Quickly learn how to copypaste rows with spreadsheet sdk in C# with this sample source code. 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 copypaste rows with spreadsheet sdk using C#.

This prolific sample source code in C# for ByteScout Data Extraction Suite contains various functions and other necessary options you should do calling the API to copypaste rows with spreadsheet sdk. 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! Enjoy writing a code with ready-to-use sample C# codes.

ByteScout provides the free trial version of ByteScout Data Extraction 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.Diagnostics;
using System.IO;
using System.Text;
using Bytescout.Spreadsheet;

namespace CopyPasteRows
{
    class Program
    {
        static void Main(string[] args)
        {
            // Open spreadsheet from file
            Spreadsheet document = new Spreadsheet();
            document.LoadFromFile(@"example.xls");
            //document.LoadFromFile(@"d:\2\1\Bytescout\Spreadsheet SDK\TestCase\Formats.xls");

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

            // Copy first eight rows to the 10th row
            worksheet.Rows.CopyAndPaste(0, 7, 9);

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