Well, the CellRangeAddress class inherits a method from the CellRangeAddressBase class with the signature isInRange(int, int). This allows you to pass the column and row indices of the cell and find out whether the cell is already part of a merged region - assuming you used a specific CellRangeAddress to create a merged region. So, all you need to do is keep track of the CellRabgeAddress objects you create whilst building the sheets and iterate through them to see whether a cell is in a merged range.
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-find-whether-excel-Cell-is-in-merged-region-having-Blank-value-tp5712357p5712358.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
