How to exclude header using tFileInputExcel

[shake]

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.

[billimmer]

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

[shake · Accepted solution]

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.