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.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.