topic Initiating "Send to Excel" from URL in QlikView

Initiating "Send to Excel" from URL

Tue, 08 Apr 2014 12:29:48 GMT

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

Re: Initiating "Send to Excel" from URL

jerrysvensson — Tue, 08 Apr 2014 13:00:15 GMT

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.

Re: Initiating "Send to Excel" from URL

Tue, 08 Apr 2014 13:07:31 GMT

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

Re: Initiating "Send to Excel" from URL

jerrysvensson — Tue, 08 Apr 2014 13:14:34 GMT

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.

Re: Initiating "Send to Excel" from URL

ToniKautto — Tue, 08 Apr 2014 13:26:21 GMT

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