Exception TFileInputExcel

[ikhalifa1616682901]

Bonjour,

J'ai une exception quand il s'agit d'un fichier excel.xlsx pourtant j'ai coché la case lire fichier excel 2007

ci joint les jar que j'ai installés

Exception in component tFileInputExcel_1 (test)

java.io.IOException: org/apache/xmlbeans/XmlObject

at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:351)

at org.apache.poi.ss.usermodel.WorkbookFactory.createXSSFWorkbook(WorkbookFactory.java:314)

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:302)

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:271)

at conversiontoafb.test_0_1.test.tFileInputExcel_1Process(test.java:625)

at conversiontoafb.test_0_1.test.runJobInTOS(test.java:1204)

at conversiontoafb.test_0_1.test.main(test.java:1053)

Caused by: java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlObject

at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:88)

at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:116)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:339)

... 6 more

Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlObject

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

... 13 more

[vikramk]

Hi @ ikhalifa1616682901,

As per my understanding, You should select the option Read Excel 2007 file format if your input file type is xlsx, or else you should unselect the same.

[ikhalifa1616682901]

Hi, thank you for your response. I did it sure but always the same error

[ikhalifa1616682901]

I have installed talend version 7.3.1 and java 8

windows 10

[vikramk]

Could you paste a snapshot of how you are configuring the file input excel component. It will help in understanding.

[ikhalifa1616682901]

thank you vikramk here are the snapshot

[Anonymous]

Hello,

It is a very simple job, it seems there is an installation issue on studio.

What's the installation path of studio? Is it working well when reinstalling your studio?

Ensure proper version of JDK is installed. For v6 of Talend products JDKv1.8 is required instead of JRE and If that requirement is met, ensure JDK bin is included in your PATH environment variable and is being reached.

Best regards

Sabrina