C# Excel - Merge Cells into One

C# Excel by Merging Cells into One

For most of Excel developers, sometimes they may have to face a problem that they have to merge two or more cells together to form one big cell whatever horizontally or vertically in a spreadsheet. However, that is very effective for laying out spreadsheet titles. Spire.XLS, a powerful .NET/Silverlight Excel component for developers, allows users to merge Excel cells into one by using C#/VB.NET and with a few sentences of code.

Download Spire.XLS here, install Spire.XLS on system and follow the simple steps below to use C# merging Excel cells.

Friendly Reminder: Please make sure Spire.XLS and Visual Studio are correctly installed on system.

Step 1 Create Project

Create a C#/VB.NET project in your visual studio. Add Spire.XLS.dll as reference. The default setting of Spire.Xls.dll is placed under "C:\Program Files\e-iceblue\Spire.Xls\Bin”. Select assembly Spire.Xls.dll and click OK to add it to the project.

using Spire.Xls;
namespace CellsMerge
{
    class Program
    {
        static void Main(string[] args)
        {
        }
    }
}

Step 2 Load Excel File

Use the code below to load Excel file in which we will merge Excel files.

            //load the excel template
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\parts.xls", ExcelVersion.Version97to2003);

Step 3 Merge Excel Files

Select the cells which we need merge into one. Follow the samples below and we can merge cells at will.

            //merge A2-D4 to one cell
            Worksheet sheet = workbook.Worksheets[0];
            sheet.Range["A2:B4"].Merge();

            //merge D5-E6 to one cell
            sheet.Range["D5:E6"].Merge();

Step 4 Save and Preview

After finish merging Excel cells, save the modified Excel file as .xls format. And we can preview what we’ve done by pressing F5 to launch the project. 

            //save the workbook
            workbook.SaveToFile(@"..\..\cellsMerge.xls", ExcelVersion.Version97to2003);

            //launch the workbook
            System.Diagnostics.Process.Start(@"..\..\cellsMerge.xls");

Let’s check out the output effective screenshot:

More about Spire.XLS:

Spire.XLS doesn't need Microsoft Office Excel Automation. It allows user to operate Excel document directly such as save to stream, save as web response, copy, lock/unlock worksheet, set up workbook properties, etc. Click to learn more…