Read Header from Excel File When Number of columns and columns names are not known.
I need to read excel file header dynamically using tFileInputExcel. If I select Dynamic schema option, first row of column name automatically gets skipped, Hence limiting row to1 is also not working. How can I read column names dynamically from excel file.
tFileInputDelimited and tFileInputFullRow not reading from excel file, hence can not use these components also.
Actually there is no way with build-in tFileXXXExcel components to do this job in talend. Please have a look at some custom tFileExcel-Components written by talend community users and shared on talend exchange portal.
It's impossible Tu use dynamic option in components... If you do not have the columns names that you want to extract. So for your case you have just to read the first line of your file using parameters {header 0 and stop reading at line 1} to get only the header. And you can do anything after.
Actually there is no way with build-in tFileXXXExcel components to do this job in talend. Please have a look at some custom tFileExcel-Components written by talend community users and shared on talend exchange portal.
