topic Re: How to read the excel data without mentioning column header in QlikView

How to read the excel data without mentioning column header

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: How to read the excel data without mentioning column header

sunny_talwar — Mon, 07 Sep 2015 07:50:13 GMT

Maybe select None under Labels.

HTH

Best,

Sunny

Re: How to read the excel data without mentioning column header

Mon, 07 Sep 2015 07:59:32 GMT

Hey Sunny

unable to get headers name if i select none

Re: How to read the excel data without mentioning column header

Anonymous — Mon, 07 Sep 2015 08:00:45 GMT

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

Re: How to read the excel data without mentioning column header

Anonymous — Mon, 07 Sep 2015 08:03:19 GMT

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

Re: How to read the excel data without mentioning column header

sunny_talwar — Mon, 07 Sep 2015 08:19:41 GMT

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

F1,

F2,

....

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

F1 as Something1,

F2 as Something2,

....

HTH

Best,

Sunny

Re: How to read the excel data without mentioning column header

Mon, 07 Sep 2015 08:22:53 GMT

i cnt make changes in excel as per client instruction

Re: How to read the excel data without mentioning column header

Anonymous — Mon, 07 Sep 2015 08:27:58 GMT

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.