This is off of the top of my head so forgive me if there are a couple of areas that I am unclear on.
1. You will have to work from the HSSFWorkbook object and call the getName(String) method defined on it. The String you pass to that method will be the name of the cell - or named region - preceded by the name of the sheet; something like Sheet1!MyCell 2. This method call should return to you an instance of the HSSFName class. It has methods defined on it that allow you to determine the index or name of the sheet the named region is on. To get at the cells address, it is likely that you will have to call the getRefersToFormula(0 of the HSSFname instance and then parse the String that will return to pull out the address of the cell. Hope that helps, if not, let us know and I will try to put a simple example together for you. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Same-named-cells-in-several-sheets-tp5683541p5683580.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]
