Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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\componentsRef: 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?
Hi
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