Interestng. The documentation appears to indicate that "CellRangeAddress" object is depricated. http://poi.apache.org/apidocs/org/apache/poi/hssf/util/CellRangeAddress.html
I have written the code and have a question on the "isInRange" method. Where is it defined and how can it compare the values in the array? MSB wrote: > > 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? >> > > ----- Pete Beatty -- View this message in context: http://old.nabble.com/Testing-for-Merged-cells-tp28811936p28817430.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]
