Detect Merged Cells in a Worksheet


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


Aspose.Cells provides the Cells.getMergedCells method which is used to get an ArrayList of merged cell areas.

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


Code Example

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