Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

11 Replies
tomasz_tru
Specialist
Specialist

You can store the data into CSV format:

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

Not applicable
Author

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
Specialist
Specialist

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
Partner - Contributor III
Partner - Contributor III

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...

Not applicable
Author

Thanks Tomasz

Not applicable
Author

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

Best regards,

Nicolò Cogno

tomovangel
Partner - Specialist
Partner - Specialist

Hi Nicolo,

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

-Angel

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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

Thanks