How to Check whether the Cell is Merged in Java

Aspose.Cells Product Family
1

I want to check whether the cell is merged, If merged how do i get the value of its parent cell, ?

2

@arshad3641

Please use the Cell.isMerged() method for your needs.

Once, you know the cell is a merged cell, then you can get merged cell range using the Cell.getMergedRange() method.

If you want to know all merged cells in a worksheet then use Worksheet.getCells().getMergedCells() method.

Reference Link:

3

Thanks a lot Shakeel