Hello everyone, its me again.
When i use a tInputFileExcel, as you can see at image below, the component doesn't return the header of first sheet file as a line, if i have two sheets, for the sheet two the component returns. What am i doing wrong?
With tFileInputExcel there are two cases:
1) Using .xls file (97-2003 format), then Uncheck the "Read excel2007 file format" option. It will not show you any error.
2) Using .xlsx file, then check the "Read excel2007 file format" option.
Try this, hope it will work.
Note: Specify the schema for excelsheet as well. And define a schema that has the maximum number of columns you can expect in all of your sheets.
Also Please let me know the output file component type, so that I can research on this. By the way I didn't find any wrong with your job.
Let me know if you require anything else.
As far as I could see from your post
Please configure the header row number, which I could see zero now.
If you choose all sheets option, all sheets should be with the same format.
If it's a different format, you may have to use new metadata created in talend.
Hi mks02, thanks for your answer.
I'm using xlsx files, thus the option "Read excel2007" is checked.
I understood your solution, but, the problem i have thought that is a talend bug,because, if I have an excel table without header, i'll loose the first line of data. It doesn't make sense.
Hi Gatha, tks for your help too.
I have made tests with the component tFileInputExcel, if source file has only one sheet and component is set to use dynamic schema, i'll loose the first line of data. Perhaps its a bug. I have the version 6.1 of Talend, and did a test with 6.2 too.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema