topic Extract All Header Columns from Excel(.xls) file in Talend Studio

Extract All Header Columns from Excel(.xls) file

tisiddiqui — Sat, 16 Nov 2024 03:17:30 GMT

Dear All,

I have a requirement in my project to extract all Column names from any given source file from Excel (.xls) file.

Column name is going to be always the first row.

I used limit as 1, Header as 0 & First Column Starts from 1.

How could i get all the column names in a single string variable with comma separated.

Re: Extract All Header Columns from Excel(.xls) file

Sujay1 — Wed, 12 Feb 2020 14:34:36 GMT

Hi @tisiddiqui can you try string concatenation and create a new field by joining all of them? Just food for thought.

Re: Extract All Header Columns from Excel(.xls) file

tisiddiqui — Sun, 23 Feb 2020 11:16:08 GMT

Dear Sujay,

I took the output of MS-EXCEL file inside Dynamic object in tjava row component.

Then read this object using Java method and extracted all the columns into a String Variable.

Regards,
Tanweer

Re: Extract All Header Columns from Excel(.xls) file

Andrew_Buffone — Tue, 01 Dec 2020 00:07:32 GMT

I am looking to do the same, can you share the tJava code you used?