I have an excel which has multiple rows and each row can have multiple images associated with that , which are postioned on a specific cells of that particular row.I know while we are positioning a image on top of a cell, that is not associated with the cell and it is actually floting the sheet of the workbook.My target is to read those images and at the same time mapping that image with particular cell using apche POI. I have two questions actually:
- Is there any way to associate an image with a excel cell so that I can read the image using POI as a cell property?
- If above point is not feasible, then is there any way that I can read the image from the excel and map that images with particular rows?
**I have attached the sample data.
I have already treid
cell.getSheet().getWorkbook().getAllPictures().. But that is returning all the images, but I don't understand which image is positioned on top of which cell.
Any help will be highly appreciated. I am waiting for your reply :).