topic Read Header from Excel File When Number of columns and columns names are not known. in Talend Studio

Read Header from Excel File When Number of columns and columns names are not known.

AChoudhari — Fri, 15 Nov 2024 22:51:37 GMT

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.

Re: Read Header from Excel File When Number of columns and columns names are not known.

InfoCraft — Sun, 05 Jun 2022 09:32:53 GMT

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.

Re: Read Header from Excel File When Number of columns and columns names are not known.

Anonymous — Mon, 06 Jun 2022 10:34:07 GMT

Hello,

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.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F542&pi=marketplace%252F1%252Fproducts%252F542%252Fitems%252F3037

Best regards

Sabrina