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

[tomasz_tru]

You can store the data into CSV format:

STORE [table] INTO [lib:\\Library/File](txt)

[#3]

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

[tomasz_tru]

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

[hoangvvo]

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;

from : http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatements...

[#6]

Thanks Tomasz

[#7]

Thanks Hoang, I think I'm gonna write a script that will do so.

Best regards,

Nicolò Cogno

[tomovangel]

Hi Nicolo,

Did you do it ?
Because I am doing something similar, and I am lost

-Angel

[#9]

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!

[tomovangel]

Unfortunately I haven't used Python, so I will be searching for another workaround

Thanks