Off of the top of my head, I think - and that is think - that I know how to get at the text boxes on an HSSFSheet. You need to do the following;
1. Get the HSSFPatriarch object for the sheet. 2. On that object, call the getChildren() method to recover a list of HSSFShapes that are on the sheet. 3. Iterate through that and check the type of each object, you are looking for any HSSFTextbox instances. 4. If you find an HSSFTextbox, cast it to the correct type and then call the getString() method to recover an HSSFRichTextString containing the objects text. Try that and see if it works, no promises though. The same code cannot be used for the SpreadsheetML (xlsx) files sadly as they have quite a different structure and you will need to dig around in the api to see if what you require is even possible. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-textbox-objects-tp3350190p3350997.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]
