I have multiple sheet in single excel , I have to read header of each sheet.
Please post the solution.
Thanks for replying,
i have tried this option before but it is give header of the 1st sheet, not from all sheets.
Please let me know some other option.
I am not sure about options in tfileInputExcel to restrict header record.
May be you can try with tMap to filter only header record from all sheets.
Here create sequence based on sheet name and filter first record from each sheet.