I've got code that reads textbox contents in .xls files that works (using HSSFPatriarch) . I'm trying to extract similar data from an Excel 2010 .xlsx file. I understand that the structure of these two file formats is very different, but how do I get at the textbox contents using POI?
I see that the objects are classified as XSSFSimpleShape (I initially expected them to be XSSFTextBox, but thats not the case - either from a file converted from Excel 2003 or saved new from Excel 2010). How do I get at the text content? I can see the string if I dump out the toString() on the xssfSimpleShape.getCTShape(), but I dont see any util methods to get at this data - is there one? Regards Nick
