Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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)
Have you checked if the file is opening without any issues in system?
Have you checked if the file is opening without any issues in system?