Read header(1st line) in Excel

param123 — Thu, 01 Aug 2019 06:18:18 GMT

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!

Re: Read header(1st line) in Excel

Anonymous — Thu, 01 Aug 2019 21:25:01 GMT

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

topic Read header(1st line) in Excel in Talend Studio

Read header(1st line) in Excel

Re: Read header(1st line) in Excel