Free Support Forum - aspose.com

HOw to get data from merged Cells

Hi,
I have a file where cells are merged vertically.

How can i read this data. I attached a table.


or weather this will be consider as one Cell or 3 Cells.

Hi,

Well, A Merged Cell is basically a single cell that is created by combining two or more selected cells.The cell reference for a merged cell is the upper-left cell in the original selected range. So, you will get data from the merged cell similar to what you get data from other cells, see the topic for reference:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/retrieving-data-from-cells.html