Hi,I already read a lot of posts, but I didn't find any solution.I'm using
the latest version (3.1.7) and I'm trying to add a JPEG image to every sheet
of one of my XLSX files; every sheet has already another JPEG image, I need
to add a logo.This is my code:
... FileInputStream input = new FileInputStream("file.xlsx"); Workbook
wb = WorkbookFactory.create(input); InputStream is = new
FileInputStream("logo.jpg"); byte[] bytes = IOUtils.toByteArray(is);
int pictureIdx = wb.addPicture(bytes, Workbook.PICTURE_TYPE_JPEG);
is.close(); CreationHelper helper = wb.getCreationHelper(); Drawing<?>
drawing; for (Sheet sheet : wb) { drawing =
sheet.createDrawingPatriarch(); ClientAnchor anchor =
helper.createClientAnchor(); anchor.setCol1(1);
anchor.setRow1(1); Picture pict = drawing.createPicture(anchor,
pictureIdx); pict.resize(); } FileOutputStream output = new
FileOutputStream("file_with_logo.xlsx"); wb.write(output);
wb.close();...
and this is the error message:
org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException: A part with
the name '/xl/media/image86.jpeg' already exists : Packages shall not
contain equivalent part names and package implementers shall neither create
nor recognize packages with equivalent part names. [M1.12] at
org.apache.poi.openxml4j.opc.OPCPackage.createPart(OPCPackage.java:869) at
org.apache.poi.openxml4j.opc.OPCPackage.createPart(OPCPackage.java:833) at
org.apache.poi.POIXMLDocumentPart.createRelationship(POIXMLDocumentPart.java:513)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.addPicture(XSSFWorkbook.java:524)
at
com.savecg.tigreplus.validation.test.TestAddLogo.main(TestAddLogo.java:49)
The incriminated line is *int pictureIdx = wb.addPicture(bytes,
Workbook.PICTURE_TYPE_JPEG);*I checked the list of pictures into the file
(by using the getAllPictures() method), and this is the list:
Name: /xl/media/image86.jpeg - Content Type: image/jpegName:
/xl/media/image87.jpeg - Content Type: image/jpegName:
/xl/media/image88.jpeg - Content Type: image/jpegName:
/xl/media/image89.jpeg - Content Type: image/jpegName:
/xl/media/image90.jpeg - Content Type: image/jpegName:
/xl/media/image91.jpeg - Content Type: image/jpegName:
/xl/media/image92.jpeg - Content Type: image/jpegName:
/xl/media/image93.jpeg - Content Type: image/jpegName:
/xl/media/image94.jpeg - Content Type: image/jpegName:
/xl/media/image95.jpeg - Content Type: image/jpegName:
/xl/media/image96.jpeg - Content Type: image/jpegName:
/xl/media/image97.jpeg - Content Type: image/jpegName:
/xl/media/image98.jpeg - Content Type: image/jpegName:
/xl/media/image99.jpeg - Content Type: image/jpegName:
/xl/media/image100.jpeg - Content Type: image/jpegName:
/xl/media/image101.jpeg - Content Type: image/jpegName:
/xl/media/image102.jpeg - Content Type: image/jpegName:
/xl/media/image103.jpeg - Content Type: image/jpegName:
/xl/media/image104.jpeg - Content Type: image/jpegName:
/xl/media/image105.jpeg - Content Type: image/jpegName:
/xl/media/image106.jpeg - Content Type: image/jpegName:
/xl/media/image107.jpeg - Content Type: image/jpegName:
/xl/media/image108.jpeg - Content Type: image/jpegName:
/xl/media/image109.jpeg - Content Type: image/jpegName:
/xl/media/image110.jpeg - Content Type: image/jpegName:
/xl/media/image111.jpeg - Content Type: image/jpegName:
/xl/media/image112.jpeg - Content Type: image/jpegName:
/xl/media/image113.jpeg - Content Type: image/jpegName:
/xl/media/image114.jpeg - Content Type: image/jpegName:
/xl/media/image115.jpeg - Content Type: image/jpegName:
/xl/media/image116.jpeg - Content Type: image/jpegName:
/xl/media/image117.jpeg - Content Type: image/jpegName:
/xl/media/image118.jpeg - Content Type: image/jpegName:
/xl/media/image119.jpeg - Content Type: image/jpegName:
/xl/media/image120.jpeg - Content Type: image/jpegName:
/xl/media/image121.jpeg - Content Type: image/jpegName:
/xl/media/image122.jpeg - Content Type: image/jpegName:
/xl/media/image123.jpeg - Content Type: image/jpegName:
/xl/media/image124.jpeg - Content Type: image/jpegName:
/xl/media/image125.jpeg - Content Type: image/jpegName:
/xl/media/image126.jpeg - Content Type: image/jpegName:
/xl/media/image127.jpeg - Content Type: image/jpegName:
/xl/media/image128.jpeg - Content Type: image/jpegName:
/xl/media/image129.jpeg - Content Type: image/jpegName:
/xl/media/image130.jpeg - Content Type: image/jpegName:
/xl/media/image131.jpeg - Content Type: image/jpegName:
/xl/media/image132.jpeg - Content Type: image/jpegName:
/xl/media/image133.jpeg - Content Type: image/jpegName:
/xl/media/image134.jpeg - Content Type: image/jpegName:
/xl/media/image135.jpeg - Content Type: image/jpegName:
/xl/media/image136.jpeg - Content Type: image/jpegName:
/xl/media/image137.jpeg - Content Type: image/jpegName:
/xl/media/image138.jpeg - Content Type: image/jpegName:
/xl/media/image139.jpeg - Content Type: image/jpegName:
/xl/media/image140.jpeg - Content Type: image/jpegName:
/xl/media/image141.jpeg - Content Type: image/jpegName:
/xl/media/image142.jpeg - Content Type: image/jpegName:
/xl/media/image143.jpeg - Content Type: image/jpegName:
/xl/media/image144.jpeg - Content Type: image/jpegName:
/xl/media/image145.jpeg - Content Type: image/jpegName:
/xl/media/image146.jpeg - Content Type: image/jpegName:
/xl/media/image147.jpeg - Content Type: image/jpegName:
/xl/media/image148.jpeg - Content Type: image/jpegName:
/xl/media/image149.jpeg - Content Type: image/jpegName:
/xl/media/image150.jpeg - Content Type: image/jpegName:
/xl/media/image151.jpeg - Content Type: image/jpegName:
/xl/media/image152.jpeg - Content Type: image/jpegName:
/xl/media/image153.jpeg - Content Type: image/jpegName:
/xl/media/image154.jpeg - Content Type: image/jpegName:
/xl/media/image155.jpeg - Content Type: image/jpegName:
/xl/media/image156.jpeg - Content Type: image/jpegName:
/xl/media/image157.jpeg - Content Type: image/jpegName:
/xl/media/image158.jpeg - Content Type: image/jpegName:
/xl/media/image159.jpeg - Content Type: image/jpegName:
/xl/media/image160.jpeg - Content Type: image/jpegName:
/xl/media/image161.jpeg - Content Type: image/jpegName:
/xl/media/image162.jpeg - Content Type: image/jpegName:
/xl/media/image163.jpeg - Content Type: image/jpegName:
/xl/media/image164.jpeg - Content Type: image/jpegName:
/xl/media/image165.jpeg - Content Type: image/jpegName:
/xl/media/image166.jpeg - Content Type: image/jpegName:
/xl/media/image167.jpeg - Content Type: image/jpegName:
/xl/media/image168.jpeg - Content Type: image/jpegName:
/xl/media/image169.jpeg - Content Type: image/jpegName:
/xl/media/image170.jpeg - Content Type: image/jpeg
Is there a way to solve the problem?Thanks in advance for any
help.Regards,Eddy
--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html
