Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: Initiating "Send to Excel" from URL

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.

Highlighted
Not applicable

Re: Initiating "Send to Excel" from URL

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

Highlighted
Partner
Partner

Re: Initiating "Send to Excel" from URL

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.

Highlighted
Employee
Employee

Re: Initiating "Send to Excel" from URL

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