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

Initiating "Send to Excel" from URL

I need to initiate the function "Send to Excel" from the web-Client. Anybody got any ideas how this can be done?

It's no problem manually right-clicking to get the context-meny in the AJAX-pivot area and choose "Send to Excel", but I want to script this from PowerShell (or AutoIt), and need a parameter in the URL to start the function...

4 Replies
jerrysvensson
Partner - Specialist II
Partner - Specialist II

There is unfortunately no built-in Actions for that.

Do it when reloading the application instead. Can be done by using the API, ServersideExportEx() for instance.

Not applicable
Author

Could you explain that a bit? My only connection to QlikView is by web-browser...

jerrysvensson
Partner - Specialist II
Partner - Specialist II

I assumed you were a developer. 🙂

When you reload the application (fetch data), you can trigger a macro to export to excel.

Talk to the developers.

ToniKautto
Employee
Employee

What you could try, is to pass a variable value in the URL and then trigger an action based on the variable change.

In the URL you can add the variable as int he example below;

qvp://localhost/MyApp.qvw?vMyVariable=0

There is no built-in action that allows an Excel export, so the best option could be a ServerSideExportEx macro. The macro is defined in the QlikView macro editor, press Ctrl+M when you are in the QlikView  desktop client. This macro will however store the export on file on the server side, which I guess is a feasible solution if you execute the export from a PowerShell script.


You can find the ServerSideExportEx definition in the API guide;

QlikView Core COM API Guide - Version 11