Excel import issue on 2019.02 CP2020.02
The Excel integration fails to import .xlsx files with this error:
Shell: Internal error. Details:
Traceback (most recent call last):
File "import_from_excel", line 315, in DiscoveryMain
File "xlsutils", line 29, in openXlFile
NoClassDefFoundError: java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile
Any .xlsx from Office365 (or earlier, I also tried Excel 2007) fails with the same error.
Workaround: Save as .xls (97-2003 excel format), the import is successful.
Re: Excel import issue on 2019.02 CP2020.02
Where any changes done to file xlsutils.py? I do not see any ZipFile class reference in the ootb script.
The error is simple. The probe does not find in its classpath the appache utility class ZipFile
In case you changed the script you could use the
java.util.ZipFile.or add the apache package to the probe class path folder.
In case the script was not changed and the documentation steps were followed then submitting a support ticket might be the best approach.