poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: Get image binary data in Excel worksheet with known filename/cell location
Date Thu, 09 Jul 2009 17:09:17 GMT

The problem you may face is that images are not placed into cells, instead,
they float on the surface of the workbook so to speak. I think that what you
will have to do is to look at the addresses of the cells that are covered by
the image and use that as your gudie; you could probably say something along
the lines of 'get me the image whose top left hand corner is in cell A1' for
example. What you will actually be after is the anchor that should be
associted with each image. That should encapsulate all of the information
you are after.

I cannot promise but if I have the time over the weekend, I will take a look
at this if timescale is not too pressing.


Mark B

TimShiu wrote:
> I would like to ask if we can get the binary data of an image if
> filename/cell location is provided?
> I found that some investigation has been made on finding the information
> of images in the excel.
> http://www.nabble.com/Copy-images-from-Workbook-to-Workbook-td23032425.html
> But it seems that the image info is separated from the image binary data.
> Currently, I'm using POI 3.5-beta 6 library.
> Many thanks.

View this message in context: http://www.nabble.com/Get-image-binary-data-in-Excel-worksheet-with-known-filename-cell-location-tp24413607p24414240.html
Sent from the POI - User mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message