topic Re: Store Excel Values in variables in QlikView

Store Excel Values in variables

Wed, 14 Mar 2012 04:09:50 GMT

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

Store Excel Values in variables

hic — Wed, 14 Mar 2012 15:25:56 GMT

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

Re: Store Excel Values in variables

Wed, 14 Mar 2012 20:46:30 GMT

That worked.. Thx!!

Re: Store Excel Values in variables

hic — Wed, 14 Mar 2012 21:07:26 GMT

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