topic Re: csv to excel file conversion in Installing and Upgrading

csv to excel file conversion

Anonymous — Sat, 16 Nov 2024 03:09:37 GMT

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

Re: csv to excel file conversion

Anonymous — Sun, 01 Mar 2020 10:19:31 GMT

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

Re: csv to excel file conversion

Anonymous — Mon, 02 Mar 2020 10:07:52 GMT

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?

Re: csv to excel file conversion

Anonymous — Tue, 03 Mar 2020 07:19:58 GMT

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

Re: csv to excel file conversion

Anonymous — Tue, 03 Mar 2020 09:07:32 GMT

Hi,

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

Thanks,

Karpagam G.

Re: csv to excel file conversion

Anonymous — Thu, 30 Apr 2020 08:42:13 GMT

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.

Re: csv to excel file conversion

ikhalifa1616682901 — Tue, 20 Apr 2021 12:43:13 GMT

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

Re: csv to excel file conversion

ikhalifa1616682901 — Tue, 20 Apr 2021 12:44:23 GMT

you find all librairies jar that i have installed