Qlik Community

Ask a Question

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense export to Excel macro

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

10 Replies
hoangvvo
Partner
Partner

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/