Hi,
I have a excel file which was downloaded from mail, but it is not recognized by Talend. below is error when i create schema manually running job.
Exception in component tFileInputExcel_1 org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: ' at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:102) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:199) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:178) at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:69) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:198)
here is some update on same error this is Open Office Excel file so please suggest me how to load this using Talend Open Studio 5.0
Open Office Excel file? Do you mean an Excel file created by Open Office or an Open Document Spreadsheet file (ods)? POI is actually bullet proof and I have never experiences any problems with API. Could you open this file outside from Talend with Excel? Are you sure you configured a correct file path, because normally I can read a complete file path in this kind or error messages.
Actually this file is created by program on Linux machine, and it has no problem to Open with Open Office. But when you try to Open it using MS Office it is not getting opened.
error describing that this is not a Excel file or format is not supported by Excel so do you want to open it or not. if i say yes then it is opening but not able to load it using Talend any suggestion.
