Read header(1st line) in Excel

[param123]

Hi,

I am trying to read the header part, from tFileinputExcel component. I tried giving all possible combinations in settings like giving header 1 and limit to 1 or just limit to 1, but i always end up getting 1st data record i.e line next to the header part which is nothing but 2nd line. 

Can someone suggest how to achieve this.

Many Thanks in advance!

[Anonymous]

Hi @rchinta ,

Please set header=0, Footer=0 and Limit=1 to read the Header. Also read the file in 2007 Format.

Thanks and Regards,

Subhadip