Extract All Header Columns from Excel(.xls) file

[tisiddiqui]

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.

[Sujay1]

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

[tisiddiqui]

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

[Andrew_Buffone]

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