Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.
I'm trying to write a macro to write qlik sense data in a new Excel file during load phase. I set
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,
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;
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!