Hello Everyone,
I'm having some trouble trying to read back some shapes from a spreadsheet. I'm
mostly interested in reading back the type of shape and the text within it. So
far my code looks like this:
FileInputStream myInput = new FileInputStream(fileName);
POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);
HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem);
HSSFSheet mySheet = myWorkBook.getSheetAt(1);
HSSFPatriarch x = mySheet.getDrawingPatriarch();
List<HSSFShape> shapeList = x.getChildren();
for (int i=0; i <shapeList.size(); i++)
{
HSSFTextbox types = (HSSFTextbox) shapeList.get(i);
System.out.println(" Shape #"+i+"Text
is"+types.getString().getString());
}
But types.getString().getString() always returns an empty string even though
the
shape has text in it. And also all the shapes returned by x.getChildren() are
HSSFTextbox
Thanks!
Al
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
