Initiating "Send to Excel" from URL

[#1]

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

[jerrysvensson]

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.

[#3]

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

[jerrysvensson]

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]

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