ByteScout Barcode Suite – C# – Unmerge cells with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Unmerge cells with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Unmerge-cells-with-spreadsheet-sdk.pdf

unmerge cells with spreadsheet sdk in C# and ByteScout Barcode Suite

unmerge cells with spreadsheet sdk in C#

The samples of source code documentation give a quick and simple method to apply a required functionality into your application. ByteScout Barcode Suite was created to assist unmerge cells 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.

If you want to quickly learn then these fast application programming interfaces of ByteScout Barcode Suite for C# plus the guideline and the C# code below will help you quickly learn unmerge cells with spreadsheet sdk. If you want to implement this functionality, you should copy and paste code below into your app using code editor. Then compile and run your application. Enjoy writing a code with ready-to-use sample C# codes to add unmerge cells with spreadsheet sdk functions using ByteScout Barcode Suite in C#.

If you want to try other samples for C# then free trial version of ByteScout Barcode Suite is available on our website.

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 UnmergeCells
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();
	document.LoadFromFile("Input.xls");

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

            // Unmerge cells
            worksheet.Range("B6:D18").UnMerge();
            // delete output file if exists already
            if (File.Exists("Output.xls")){
                File.Delete("Output.xls");
            }

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

            // Close Spreadsheet
            document.Close();

            // open generated XLS document in default program
            Process.Start("Output.xls");

        }
    }
}