topic Re: How to read xls file format. in Talend Studio

How to read xls file format.

Anonymous — Sat, 16 Nov 2024 03:47:24 GMT

HI,

I am trying to read Excel file (.xls) format and run the job.but the below mention errors are shown, then how to solve this problem, help me

Exception in component tFileInputExcel_1 (PartnerCashoutReport)
jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at local_project.partnercashoutreport_0_1.PartnerCashoutReport.tFileInputExcel_1Process(PartnerCashoutReport.java:1250)
at local_project.partnercashoutreport_0_1.PartnerCashoutReport.runJobInTOS(PartnerCashoutReport.java:2295)
at local_project.partnercashoutreport_0_1.PartnerCashoutReport.main(PartnerCashoutReport.java:2145)

Re: How to read xls file format.

karthikj18 — Wed, 18 Dec 2019 16:58:52 GMT

Please try the below steps.

Check if "read excel2007 file format(xlsx)" option is disabled.

Check if the excel file is opening without any issues.

Re: How to read xls file format.

Anonymous — Thu, 19 Dec 2019 05:50:52 GMT

hi,

I am already done to check it for disabling the "read excel2007 file format(xlsx)" option.

the same error is shown.

Exception in component tFileInputExcel_1 (PartnerCashoutReport)
jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at local_project.partnercashoutreport_0_1.PartnerCashoutReport.tFileInputExcel_1Process(PartnerCashoutReport.java:1297)
at local_project.partnercashoutreport_0_1.PartnerCashoutReport.runJobInTOS(PartnerCashoutReport.java:2356)
at local_project.partnercashoutreport_0_1.PartnerCashoutReport.main(PartnerCashoutReport.java:2206)

Capture1.JPG

Re: How to read xls file format.

sreemanthri — Thu, 19 Dec 2019 06:45:31 GMT

You need to install jxl jar file

Re: How to read xls file format.

karthikj18 — Thu, 19 Dec 2019 15:24:41 GMT

Have you checked if the file is opening without any issues in system?

Re: How to read xls file format.

Anonymous — Fri, 20 Dec 2019 06:06:41 GMT

am Installed jxl jar file , but the issue is not solved.

Re: How to read xls file format.

Anonymous — Fri, 20 Dec 2019 06:08:54 GMT

still am facing the same issue, how to solve it. anyone help me.

Re: How to read xls file format.

karthikj18 — Fri, 20 Dec 2019 16:09:33 GMT

Have you checked if the file is opening without any issues in system?