How to read the excel data without mentioning column header

[#1]

Hi All,

How to script without mentioning header line ????? while loading the excel data .

(ooxml, embedded labels, header is 4 lines, table is [Dept]);

Please suggest

[sunny_talwar · Accepted solution]

Maybe select None under Labels.

HTH

Best,

Sunny

[#3]

Hey Sunny

unable to get headers name if i select none

[Anonymous]

hi revathi,

Goto File wizard transform and delete rows and columns not required,but with this solution in script n statements for rows and columns will be displayed which is worse than header line mentioned.

other solution is request source provider to give spreadsheets with only one header(Change the format).

Regards

Neetha

[Anonymous]

you can rename column names with header names from excel ,if none is selected

[sunny_talwar]

I think once you do what I suggested, you should get something like this:

F1,

F2,

F3

....

You can name them to be whatever you want like this:

F1 as Something1,

F2 as Something2,

....

HTH

Best,

Sunny

[#7]

i cnt make changes in excel as per client instruction

[Anonymous]

yes you can't change with out clients instructions but request them to provide data with format( one line header)

you can follow sunny's solution and rename fields in UI with header names from excel.