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

[ikhalifa1616682901]

thank you for your response can you help me more please here are snapshot of my environment variable and version of jdk

[Anonymous]

Hello,

Hope this online installation documentation helps.

TalendHelpCenter: Setting up JAVA_HOME

Best regards

Sabrina

[ikhalifa1616682901]

Hello,

I already did like that but it's still the same error 😥

[Anonymous]

Hello,

Could you please reinstall your studio to see if it works?

Best regards

Sabrina

[gjeremy1617088143]

Hi , i think you have to define a schema for the excel file, maybe first try create metadata with your excel document.

Send me Love and Kudos