Detect Merged Cells in a Worksheet

Demonstration

This example uses a template Microsoft Excel file called MergeTrial. It has some merged cell areas in a sheet also called Merge Trial.

The template file

todo:image_alt_text

Aspose.Cells provides the Cells.getMergedCells() method which is used to get all merged cells.

When the code below is executed, it clears the contents of the sheet and unmerges all the cell areas before saving the file again.

The Output File

todo:image_alt_text

Code Example

Please see the following sample code to find how to identify merged cell areas in a worksheet and unmerge them.