Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-12-18 10:14 AM

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)

Labels (3)
Labels
164 Views
0 Likes
7 Replies
karthikj18
Contributor III
Contributor III
‎2019-12-18 11:58 AM

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.

 

164 Views
0 Likes
Anonymous
Not applicable
‎2019-12-19 12:50 AM
Author

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
164 Views
0 Likes
sreemanthri
Contributor
Contributor
‎2019-12-19 01:45 AM

You need to install jxl jar file
164 Views
0 Likes
karthikj18
Contributor III
Contributor III
‎2019-12-19 10:24 AM

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

164 Views
0 Likes
Anonymous
Not applicable
‎2019-12-20 01:06 AM
Author

am Installed jxl jar file , but the issue is not solved.
164 Views
0 Likes
Anonymous
Not applicable
‎2019-12-20 01:08 AM
Author

still am facing the same issue, how to solve it. anyone help me.
164 Views
0 Likes
karthikj18
Contributor III
Contributor III
‎2019-12-20 11:09 AM

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

164 Views
0 Likes