Qlik Sense export to Excel macro

[#1]

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

[hoangvvo]

There are ways to do this but it depends on if you want to take the time to learn. I have qlik sense server generate a csv file using store command, then have a program called Macro Scheduler that watch the folder for .csv file, reads it and convert and layout the file for me. Macro scheduler is a scripting language, that basically means you can run have any scripting language: ie. AutoHotkey is a free scripting language that reads the csv file and create an excel file: here's the link to the ahk forum: https://autohotkey.com/board/topic/69033-basic-ahk-l-com-tutorial-for-excel/

[EricJones728]

Would you be willing to share your python script?  Looking to do something similar.