Store Excel Values in variables

[#1]

Hi,

I have got a spreadsheet with some values stored in a column. Now I need to extract this into Qlikview and store the values of different rows of the column into separate variables in Qlikview.

How do I do that?

Cheers

[hic · Accepted solution]

ExcelData:

LOAD Field FROM [File.xlsx] (ooxml, embedded labels);

Let vVariable1 = peek('Field',0,''ExcelData'); // Row 1

Let vVariable2 = peek('Field',1,''ExcelData'); // Row 2

[#3]

That worked.. Thx!!

[hic]

Here is an example that shows how I mean. Put both files in the same folder and it will work. The script also contains a loop that you can use if you want to define both Names and Values of the variables in the Excel sheet.

/HIC