Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 🙂
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