Hi, I think we share a common problem. Though the approach is different. I filed a bug a while ago: https://issues.apache.org/bugzilla/show_bug.cgi?id=53568
-----Original Message----- From: y.Gao [mailto:[email protected]] Sent: 31. heinäkuuta 2012 18:24 To: [email protected] Subject: get Image from excel 2010 Hallo I want to get a Picture from a workbook, I can get the Image in excel2003, but not in excel 2007. code as follows // get all pictures List<XSSFPictureData> pictures = workbook.getAllPictures(); XSSFSheet sheet = workbook.getSheetAt(0); //Make a mapping of Interger and XSSFPictureData Map<Integer,XSSFPictureData> map = new HashMap<Integer,XSSFPictureData>(); for (XSSFShape shape : sheet.getDrawingPatriarch().getChildren()) { XSSFClientAnchor anchor = (XSSFClientAnchor) shape.getAnchor(); int rowIndex = anchor.getRow1(); if (shape instanceof XSSFPicture) { int rowmark = rowIndex; XSSFPicture picture = (XSSFPicture) shape; int pictureIndex = picture.getPictureIndex() - 1; XSSFPictureData pictureData = pictures.get(pictureIndex);// map.put(rowmark, pictureData); In HSSFSheet and HSSFPicture have the method sheet.getDrawingPatriarch() and getPictureIndex(). But there is no such method getDrawingPatriarch() in XSSFSheet and getPictureIndex() in XSSFPicture, Is there any way to get location of Picture and Index of Picture. I am using POI-3.8 Regards -- View this message in context: http://apache-poi.1045710.n5.nabble.com/get-Image-from-excel-2010-tp5710579.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- 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]
