topic Re: Execute Qlik Code stored in Excel in App Development

Execute Qlik Code stored in Excel

rneelakantam — Wed, 29 May 2019 13:28:07 GMT

Hi All,

I have my Qlik code store in Excel. Now i want to load from excel and execute the code in Qlik.

Note : I cant store the code in txt or qvs file and use include script

Thanks in Advance

Re: Execute Qlik Code stored in Excel

rwunderlich — Wed, 29 May 2019 14:54:06 GMT

When you say "code", do you mean load script?

-Rob

Re: Execute Qlik Code stored in Excel

LReeve — Wed, 29 May 2019 15:57:20 GMT

Assuming you are storing your load script in a single cell then you should be able to do this:

LOAD "Script" FROM [lib://Downloads/DataLoad.xlsx] (ooxml, embedded labels, table is Sheet1); Let vScript = Peek('Script'); $(vScript); Drop Table Sheet1;

If each line of the script is in a new Excel row you should be able to do something like (untested):

LOAD Concat("Script"&chr(10)) FROM [lib://Downloads/DataLoad.xlsx] (ooxml, embedded labels, table is Sheet1);