I do not have the code to hand but the technique that I have used in the past goes like this.
Open the worksheet. Call the getNumMergedRegions() methods to recover an integer that indicates how manymerged regions there are on the sheet. Use this value to create and dimension an array of type CellRangeAddress. Use this value again to iterate through all of the merged regions - use a for() loop - calling the getMergedRegion(int) method and storing the returned CellRangeAdress object into the array. Now when you encounter a cell, you can iterate through the objects in the cell range address array and call the isInGange(int, int) method passing the row and column indeices of the cell. That will return a boolean value indicating whether or not the cell is contained within the range. Yours Mark B pb2208 wrote: > > I am parsing a spreadsheet and need to skip processing for an merged > cells. How can i test a cell to see if it is part of merged set of cells? > -- View this message in context: http://old.nabble.com/Testing-for-Merged-cells-tp28811936p28814291.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]
