How to Display Excel sheet Column name

[Anonymous]

Hi All,

I'm Loading data from excel sheet to my .qvw file and trying to use the column name but i can't use it.

My Script is :

LOAD A, B, C,D,E,F,G,H,I,J,K,L,M,N,O
FROM

(ooxml, no labels);

My excel sheet column are like Proj_id,EmpID,Location,Defect_ID,Def_Status,Closing_Date

My Question is :

1. I want to display my column name instead of A,B,C when am performing some calculation OR action?

[Roop]

Use the Embedded Labels drop down just below the header size.

[sagarkharpude]

Select embedded Labels while loading the data

[#4]

Hi,

Use Embeded Label in while loading the data see attached file

Thanks

Manju

[datanibbler]

Hi,

just try some different settings in the wizard (when loading the sheet) with the nr. of lines to use as header. If your Excel_sheet does have column_names, you should get those.

[Anonymous]

hi,

sorry i couldn't find the option file wizard in my .qvw file

[#7 · Accepted solution]

First u click on the table files in edit Script

  select the path of the source file once u sleeted automatically File Wizard pop_up will come u can find the Label option over there  just u select drop down u will find option called Embedded labels select that

[sagarkharpude]

You will find file wizard option after selecting the excel from your desktop location.

(ooxml, no labels);

and above no labels will get replaced by Embedded labels

(ooxml, embedded labels, table is Sheet1);