How to read .XLS file and last row skip

[Anonymous]

Hi Guys,

I'm new to Talend. I'm facing problem.

1.I can't able to read the data's from XLS files.

2.I'm try to import data using .csv and .xlsx format. It will works. But my files last row have the total i don't want to insert last row how to do this.
Can some one help me on this.

[Anonymous]

hello @vivek_sivam 

To skip last few rows in excel just mention the number in limit field.
For example if you want to skip last 501 row just put 500  of tFileInputExcel basic settings limit 

also check excel file format is it 2007 or any, also for better understandings plz share screenshot of error msg.

thanks,

Warm Regards,
Manish Suryawanshi,

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi @vitspltalend
I'm getting below error message
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)

[Anonymous]

I have met this issue before, but I'm not sure it is the same occasion with yours. Usually, I will check out the option "Read excel 2007 file format(xlsx)".
Best regards
manish