Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hi
Using Merge Excel documents (v2.2.18 of plugin on Appian 22.1) has been working very successfully. Now shows an error -
Merge Excel Documents A part with the name '/docProps/core.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12].
Any ideas as to cause and how to overcome this error?
Regards
Hi,
Issue resolved (sort of) - open and save source excel manually before using merge service.
A log extract showing error
2022-06-28 18:30:54,015 [Appian Work Item - 272 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=247948, classname=com.appiancorp.ps.exceltools.smartservice.MergeExcelDocuments org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the name '/docProps/core.xml' 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.addPackagePart(OPCPackage.java:941) at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:547) at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1490) at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1477) at org.apache.poi.openxml4j.opc.ZipPackage.closeImpl(ZipPackage.java:472) at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:464) at org.apache.poi.ooxml.POIXMLDocument.close(POIXMLDocument.java:189) at org.apache.poi.xssf.usermodel.XSSFWorkbook.close(XSSFWorkbook.java:609) at com.appiancorp.ps.exceltools.smartservice.MergeExcelDocuments.mergeExcelFiles(MergeExcelDocuments.java:147) at com.appiancorp.ps.exceltools.smartservice.MergeExcelDocuments.run(MergeExcelDocuments.java:95) at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:136)
A quick search shows this to be a known bug in the docfetcher module and is fixed in 1.1.15 (DocFetcher / Bugs / #987 A part with the name '/docProps/core.xml' already exists (sourceforge.net)).
Will upgrade to latest version of plugin cure this issue?