topic Re: Exception TFileInputExcel in Talend Studio

Exception TFileInputExcel

ikhalifa1616682901 — Sat, 16 Nov 2024 00:14:22 GMT

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

Re: Exception TFileInputExcel

vikramk — Wed, 21 Apr 2021 06:26:30 GMT

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.

Re: Exception TFileInputExcel

ikhalifa1616682901 — Wed, 21 Apr 2021 07:52:24 GMT

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

Re: Exception TFileInputExcel

ikhalifa1616682901 — Wed, 21 Apr 2021 07:57:32 GMT

I have installed talend version 7.3.1 and java 8

windows 10

Re: Exception TFileInputExcel

vikramk — Wed, 21 Apr 2021 10:45:48 GMT

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

Re: Exception TFileInputExcel

ikhalifa1616682901 — Wed, 21 Apr 2021 11:03:06 GMT

thank you vikramk here are the snapshot

Re: Exception TFileInputExcel

ikhalifa1616682901 — Wed, 21 Apr 2021 11:06:50 GMT

Re: Exception TFileInputExcel

ikhalifa1616682901 — Wed, 21 Apr 2021 11:06:59 GMT

Re: Exception TFileInputExcel

ikhalifa1616682901 — Wed, 21 Apr 2021 11:07:09 GMT

Re: Exception TFileInputExcel

Anonymous — Thu, 22 Apr 2021 06:27:29 GMT

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

Re: Exception TFileInputExcel

ikhalifa1616682901 — Thu, 22 Apr 2021 07:31:07 GMT

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

Re: Exception TFileInputExcel

Anonymous — Thu, 22 Apr 2021 07:50:19 GMT

Hello,

Hope this online installation documentation helps.

TalendHelpCenter: Setting up JAVA_HOME

Best regards

Sabrina

Re: Exception TFileInputExcel

ikhalifa1616682901 — Thu, 22 Apr 2021 08:05:08 GMT

Hello,

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

Re: Exception TFileInputExcel

Anonymous — Fri, 23 Apr 2021 08:25:18 GMT

Hello,

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

Best regards

Sabrina

Re: Exception TFileInputExcel

gjeremy1617088143 — Fri, 23 Apr 2021 08:31:41 GMT

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