Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I'm trying to write a macro to write qlik sense data in a new Excel file during load phase. I set
OverrideScriptSecurity=1
StandardReload=0
inside the Settings.ini file and I'm using these commands
Set XLApp = CreateObject("Excel.Application") ;
XLApp.Visible = True ;
inside the script, but I can't see anything working
What am I doing wrong?
Thanks a lot for your help in advance,
best regards,
Nicolò Cogno
You can store the data into CSV format:
STORE [table] INTO [lib:\\Library/File](txt)
Hi Thomas,
I knew that, but I'd like to store into XLSX file and that's why I'm trying to write a macro to do so.
Thanks
Nicolò Cogno
I don't think it's possible to do it in Qlik Sense. But if you give extension 'xls' to a CSV file Excel will open it
I dont think you can do it in qlik sense, but you can execute a script if you disable the default load. I use sense server and disabling it is not an option, but i've read up the qlik help that you can execute a file from sense .. and i think you can also set sense to wait for that file to finish... i would check qlik help.
Execute C:\Program Files\Office12\Excel.exe;
Execute winword macro.doc;
Execute cmd.exe /C C:\BatFiles\Log.bat;
Thanks Tomasz
Thanks Hoang, I think I'm gonna write a script that will do so.
Best regards,
Nicolò Cogno
Hi Nicolo,
Did you do it ?
Because I am doing something similar, and I am lost
-Angel
Hi Angel,
unfortunately not . I solved with python and Qlik: using qlik store function I create csv files with the tables and then I use the execute function to launch python scripts that convert the csv to xlsx files.
Let me know if you solve in other ways!
Unfortunately I haven't used Python, so I will be searching for another workaround
Thanks