Not sure if this is the best way or not.
I have found with XSLX, it's much easier to unzip the file and go
through the media directory and grab an image that I need rather than
trying to do it with the POI API. It's a hack but it works.
On 3/3/2014 5:42 PM, Steve Lamont wrote:
Dear all:
I'm a complete noob usign Apache POI so I may be making some sort of
complete dunderheaded move, but I've done a bit of experimentation and
spent a few hours going through the Javadocs and I'm unable to see how
to extract Picture objects from an existing XLS or XLSX spreadsheet.
HSSFCell.getCellType() and XSSFCell.getCellType() both return
CELL_TYPE_BLANK for cells containing an image.
While I can get the picture data itself with HSSFWorkbook.getAllPictures()
I don't see any method for associating a HSSFPictureData object with
a cell. I'm sure I'm missing something astoundingly obvious but
I don't see it.
Is there a way to do this that I'm missing?
Thanx.
spl
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
