topic Re: Download file from Sharepoint (OOXML error) in Talend Studio

Download file from Sharepoint (OOXML error)

Anonymous — Thu, 26 Mar 2020 21:23:25 GMT

Hi,

I have downloaded .xlsx file from SharePoint but if I am trying to read it through tFileInputExcel it throws below error-

Exception in component tFileInputExcel_2 (test11)
org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:286)
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:758)
at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:90)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:336)
at local_project.test11_0_1.test11.tFileInputExcel_2Process(test11.java:1254)

To get URI in tFileFetch from SharePoint I have right-clicked on file and did "copy link". Let me know if more info is required.

Please note, I am also unable to open that Excel file manually by double-clicking, it says file format/extension is not valid or file is corrupted.

Regards,

Ravi

Re: Download file from Sharepoint (OOXML error)

Anonymous — Fri, 27 Mar 2020 01:27:54 GMT

Hi Ravi
It seems the file has been corrupted during downloading with tfileFetch if you can't open it manually. Can you try to download the file manually and see if you are able to open it?

Regards
Shong

Re: Download file from Sharepoint (OOXML error)

Anonymous — Fri, 27 Mar 2020 05:28:17 GMT

Hi Shong,

Yes, I am able to download it manually and it opened fine.

The problem comes only while downloading with Talend.

Sharing further details with you of tFileFetch and Excel components:

Excel:

Please note- I am not able to attach Talend downloaded excel herewith post as it throws an error- "The contents of the attachment doesn't match its file type".

Regards,

Ravi

Re: Download file from Sharepoint (OOXML error)

Anonymous — Tue, 31 Mar 2020 20:29:09 GMT

Hi Shong,

Any idea on this, I am stuck.

Trying with trestclient as well but no luck.

Regards,

Ravi