Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

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

Tags (1)
10 Replies
tomasz_tru
Valued Contributor

Re: Qlik Sense export to Excel macro

You can store the data into CSV format:

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

Not applicable

Re: Qlik Sense export to Excel macro

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
Valued Contributor

Re: Qlik Sense export to Excel macro

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

Re: Qlik Sense export to Excel macro

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

Re: Qlik Sense export to Excel macro

Thanks Tomasz

Not applicable

Re: Qlik Sense export to Excel macro

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

Best regards,

Nicolò Cogno

tomovangel
Contributor III

Re: Qlik Sense export to Excel macro

Hi Nicolo,

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

-Angel

Not applicable

Re: Qlik Sense export to Excel macro

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

Re: Qlik Sense export to Excel macro

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

Thanks

Community Browser