ByteScout Data Extraction Suite – C# – Merge cells with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Merge cells with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Merge-cells-with-spreadsheet-sdk.pdf

How to merge cells with spreadsheet sdk in C# with ByteScout Data Extraction Suite

If you want to learn more then this tutorial will show how to merge cells with spreadsheet sdk in C#

Merge cells with spreadsheet sdk is simple to apply in C# if you use these source codes below. ByteScout Data Extraction Suite: 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 merge cells with spreadsheet sdk in C#.

These C# code samples for C# guide developers to speed up coding of the application when using ByteScout Data Extraction Suite. Simply copy and paste in your C# project or application you and then run your app! If you want to use these C# sample examples in one or many applications then they can be used easily.

The trial version of ByteScout Data Extraction Suite can be downloaded for free from our website. It also includes source code samples for C# and other programming languages.

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 MergeCells
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();

            // Get worksheet by name
            Worksheet worksheet = document.Workbook.Worksheets.Add("Sheet1");
            
            // Merge cells
            worksheet.Range("B6:D18").Merge();

            // Write text
            worksheet.Cell("C10").MergedWithCell.Value = "Bytescout.Spreadsheet";


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