topic Re: Talend not reading .xls file in Talend Studio

Talend not reading .xls file

Anonymous — Thu, 21 Feb 2013 15:09:11 GMT

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

Re: Talend not reading .xls file

Anonymous — Thu, 21 Feb 2013 19:57:19 GMT

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.

Re: Talend not reading .xls file

Anonymous — Fri, 22 Feb 2013 11:44:36 GMT

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.

Re: Talend not reading .xls file

Anonymous — Tue, 04 Jun 2013 13:19:52 GMT

Is there any components in Talend for processing .ods (Open Office document) files

Re: Talend not reading .xls file

Anonymous — Tue, 04 Jun 2013 13:54:41 GMT

Hi Rathinasamy
There is no component to read Open office files, rather you can, you can used Jsoup to parse ods file xml.

Re: Talend not reading .xls file

Anonymous — Wed, 05 Jun 2013 04:15:13 GMT

Hi rathinasamyy,
I have replied your related forum https://community.talend.com/t5/Design-and-Development/Talend-component-for-processing-open-office-document-ods-file/td-p/110017.
Please check it.
Best regards
Sabrina