topic Re: How to exclude header using tFileInputExcel in Talend Studio

How to exclude header using tFileInputExcel

shake — Thu, 21 May 2020 20:42:13 GMT

I am using tFileInputExcel to read data from an Excel file. I have a header row that I would like to skip in the Excel file. Because of this my Header setting is 1:

My Excel file looks like this. Notice that the second column is a "date" type.

When I run the job, it errors and gives me this message:

From what I can see, it is telling me that the value in row 1 column 2 is not a date. However, I am telling it to skip the header row. Do my header values have to be the data type of the column, even if I am telling it to skip the row? Is there some other setting that I am missing?

Thanks for any thoughts.

Re: How to exclude header using tFileInputExcel

billimmer — Thu, 21 May 2020 22:34:38 GMT

I just tested this on TOS 6.4 and it works if i make the header 1. It failed with the same error you got with header = 0

Re: How to exclude header using tFileInputExcel

shake — Fri, 22 May 2020 00:11:07 GMT

Thanks for the response.

I think I figured out my problem. I think it was actually skipping my header, but the date format in my cell was not matching my mask exactly. Once I fixed that, it worked.

It appears that when you skip the header row, the error then considers the first row thereafter as row 1. That was what confused me because I thought it was referring to the header row.