What you describe is perfectly normal behaviour. For a merged region of cells, the entire contents of that merged region will be contained within the cell at the top left hand corner of the merged region and reading any of the other cells in that region will, as you found out, return an odd looking value. The way to get around this is to ask if the cell is part of a merged region and, if it is, to get the addresses of all the other cells in that region. Then, when you read another cell, check if it is in the merged region and, if it is, simply return the value that you read from that first cell.
If you look through the javadocs for the API, all of the support you need is already there. If memory serves, it is possible to discover how many merged regions there are on a sheet and to get each individual merged region by index from the sheet. Also, I think that the CellRangeAddress class has a method that allows you to test if a cell is within a range using it's row and column indices. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Problem-in-reading-data-from-merged-cells-in-excel-using-XSSF-tp5512364p5513442.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
