How to read xls file format.

Highlighted
Six Stars

How to read xls file format.

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)

Seven Stars

Re: How to read xls file format.

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.

 

Highlighted
Six Stars

Re: How to read xls file format.

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)

Highlighted
Five Stars

Re: How to read xls file format.

You need to install jxl jar file
Highlighted
Seven Stars

Re: How to read xls file format.

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

Highlighted
Six Stars

Re: How to read xls file format.

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

Re: How to read xls file format.

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

Re: How to read xls file format.

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog