tFileExcelWorkbookOpen -- is not working correctly to read .xlsx or .xlsm files

Tasfiahm — Sat, 16 Nov 2024 00:55:10 GMT

I am trying to use the

tFileExcelWorkbookOpen to open a .xlsx and .xlsm file. None of the file is opening.

I have downloaded the component from the Talend Enchange. I am using Talend 7.2.

I have copied the component into the Talend installation folder:

C:\Talend-Studio-V7.2.1\plugins\org.talend.designer.components.localprovider_7.2.1\components

Ref: picture 1

The component showing in the palette under File>Spreadsheet

tFileExcelWorkbookOpen-- for the setup I have only define the file location and name:

I am getting the below error. I have tried to open different types of excel files:

[statistics] connecting to socket on port 3816

[statistics] connected

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.put(Ljava/lang/Object;)V

at org.apache.poi.xssf.model.SharedStringsTable.<clinit>(SharedStringsTable.java:94)

at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61)

at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:684)

at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:180)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:288)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:309)

at de.jlo.talendcomp.excel.SpreadsheetFile.initializeWorkbook(SpreadsheetFile.java:389)

Talend Modules .jar files for the component:

I have tried multiple way to solve the issue but getting out of luck. So does any one have any idea about the problem and the solution?

Re: tFileExcelWorkbookOpen -- is not working correctly to read .xlsx or .xlsm files

Anonymous — Tue, 22 Dec 2020 03:45:59 GMT

What is your JDK version? I just made a testing on my machine and it works.

Windows 10

Java 1.8

Talend Studio 7.3.1

Regards

Shong