Unfortunately, POI does not fully support reading properties of shapes
from binary Excel files (.xls).
This is a rather fundamental limitation of POI-HSSF: it can create
simple drawings from scratch, but cannot modify or read existing ones.
reading basic shape properties is simple:
HSSFPatriarch drawing = sheet.getDrawingPatriarch();
for(HSSFShape sh : drawing.getChildren()){
HSSFAnchor anchor = sh.getAnchor(); // position of the shape on the sheet
if(sh instanceof HSSFTextbox){
....
} else if instanceof HSSFPicture){
...
}
}
getting adjustment values and formatting (color, border, etc.) is not
supported.
Yegor
On Thu, Feb 2, 2012 at 12:38 PM, pratik sharma <[email protected]> wrote:
> Hi i am looking for a sample code to Render Shape and get data about the
> Shape (Data like Shape Name, Adjustment value, height, width etc) for 2003
> excel.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
