This week's book giveaway is in the Agile forum.
We're giving away four copies of The Software Craftsman and have Sandro Mancuso on-line!
See this thread for details.
The moose likes Other JSE/JEE APIs and the fly likes How to get an image and its position from excel file using Apache POI? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "How to get an image and its position from excel file using Apache POI?" Watch "How to get an image and its position from excel file using Apache POI?" New topic
Author

How to get an image and its position from excel file using Apache POI?

Gianni Amendola
Greenhorn

Joined: Jul 23, 2012
Posts: 1
Is it possible to extract an image's information from an xls spreadsheet using Apache POI?

In one of my projects, I need to read some images from a .xls file. I can read all images together, but how can I get images position (like columns and rows number or coordinates)? Otherwise I can get images position but I can't know information, like picture name or extension or others, about a specific image at the positions found. How I can get images and positions too?

Here: read all images...
and here: get images positions...
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42954
    
  73
Start here: http://poi.apache.org/spreadsheet/quick-guide.html#Images.

Check out the ClientAnchor interface for information about where/how the position is saved.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to get an image and its position from excel file using Apache POI?