csv to excel file conversion

[Anonymous]

Hi
I am getting this error for covertion of csv file to excel file.

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlObject

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:240)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:210)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:185)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:272)

at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:134)

at local_project.csvtoexcel_0_1.CSVtoEXCEL.tFileInputDelimited_1Process(CSVtoEXCEL.java:499)

at local_project.csvtoexcel_0_1.CSVtoEXCEL.runJobInTOS(CSVtoEXCEL.java:996)

at local_project.csvtoexcel_0_1.CSVtoEXCEL.main(CSVtoEXCEL.java:846)

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

at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown Source)

at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(Unknown Source)

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

... 8 more

. Plz do the needful.
I'm installed talend open studio data integration 7.2

[Anonymous]

Hi karpagam

It is a very simple job, it seems there is an installation issue on studio. Can you provide the following information?
Which JAVA version?
Which Operating system?
The installation path of studio?

Regards
Shong

[Anonymous]

Hi,

 I have jdk and jre version 10 in my system.

When checked with the compatibility settings, it says the recommended version as 8 and supported version 11.

Will this be an issue  because of which the job is not getting executed successfully?

[Anonymous]

Hi
We do not make any testing for other version of JDK, so we can not make sure it works as expected if you are using non-supported version of JDK, and we will not provide any help or support on this.

Regards
Shong

[Anonymous]

Hi,

Thanks for your information and I will install the supported version of jdk and jre in my machine.

Thanks,

Karpagam G.

[Anonymous]

---

mcdvoice wrote:
Hi
We do not make any testing for other version of JDK, so we can not make sure it works as expected if you are using non-supported version of JDK, and we will not provide any help or support on this.

Regards
Shong

---

Thank you so much for helping with this wonderful post.

[ikhalifa1616682901]

I have the same problem :

Talend version 7.3

windows 10

java 8

can you help me please

Exception in component tFileInputExcel_1 (BNP_Bruxelles1)

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.bnp_bruxelles1_0_1.BNP_Bruxelles1.tFileInputExcel_1Process(BNP_Bruxelles1.java:1837)

at conversiontoafb.bnp_bruxelles1_0_1.BNP_Bruxelles1.runJobInTOS(BNP_Bruxelles1.java:3861)

at conversiontoafb.bnp_bruxelles1_0_1.BNP_Bruxelles1.main(BNP_Bruxelles1.java:3710)

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]

you find all librairies jar that i have installed