Unable to fetch the data from excel(.xls) file

[Anonymous]

Guys,

I'm facing weird issue while reading .xls file. File is not fetching any data rows even there is data present in a excel file. I'm not getting any error.

If I read same file from repository (metadata) I'm getting the data rows but there will be multiple files so cannot use metadata.

Any idea about this?  

[Anonymous · Accepted solution]

Nikhil/Guys Thanks for reply.

I found the actual problem. While reading this file i'm checking filter empty row checkbox in advanced tab.

whenever i'm doing that it is reading 0 rows. When I unchecked this I'm able to read the data. I used tFilterRow to filter NULL values.

@talend Team,

This may be a bug in Talend Studio. I'm using Talend Data Management 6.5.1 platform(Enterprise version).

Thanks,

Sanjay