Usage of MergeRanges

[Administrator]

Does anyone has a sample or knows how to use MergeRanges method of the Worksheet.

We are looking if Syncfusion XlsIO support cell merge programatically.

Thanks .

[Lokesh R]

Hi Erick,

Thank you very much for your interest on Syncfusion products.

MergeRanges method:

The MergeRanges() method is used to merge the range index not the actual cells,
For eg:
sheet.MergeRanges(wkSheet.Range["A1:A3"], wkSheet.Range["B1:B3"]);

It will return the IRange object with the address value as 'Sheet1'!A1:B3.

Cell merge:

Yes, in XlsIO it is possible to merge the cells by using Merge() method associated with the IRange .
For eg:
wkSheet.Range["C1:C3"].Merge();
the cells from C1 to C3 will be merged into a single cell.

I have created a sample which explains both the methods. Please, try the sample from the below link and let us know if this helps you.

Sample link:

http://help.syncfusion.com/samples/XlsIO.Windows/94176.zip


Please, let me know if you need any clarifications.

Thanks,
Lokesh