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 Paul, could you please let me know the configuration to merge excel. The second excel is not starting from the specified cell position. Even if we mention a cell, the second excel value starts from bottom of first excel
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?