topic Automation of Excel outputs in QlikView

Automation of Excel outputs

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

We have qlikview server installed in our company NOT qlikview publisher.

We can schedule automatic reloads on the server but is there a way that we can automate outputing files from excel to pecific locations without having to manually do this.

For example, pivot tables are reloaded daily but we are manually exporting them from qlikview.

Regards,

Gregg

Automation of Excel outputs

Thu, 03 May 2012 18:07:50 GMT

Within the qvw, write a macro that will export charts to excel. Configure a document trigger that will fire the macro OnPostReload. Reload the document using a batch file (not the server scheduler). The batch file would have a line similar to this: c:\program files\qlikview\qv.exe -R d:\application.qvw

the batch file can then be scheduled to run via windows task scheduler.

when reloading using qlikview server or publisher, macro execution is ignored.. that's why you have to reload using batch mode.

Automation of Excel outputs

rwunderlich — Fri, 04 May 2012 03:24:41 GMT

You may want to consider using one of the 3rd party products. -- QvExcel, Nprinting or CIA Reporter.

-Rob

Re: Automation of Excel outputs

Tue, 08 May 2012 11:05:08 GMT

Hi Tammy,

Thanks for that.

I have set everything up, however, I have section access in my script.

Do you know where I would put in the login details if I was to set up a batch file to reload the document?

At the moment, it stalls when trying to open the application.

Regards,

Gregg

Re: Automation of Excel outputs

Tue, 08 May 2012 12:58:30 GMT

hi Gregg-

you can add SERIAL to the section access, and provide the qv serial # for the machine that is doing the reload. i've attached an example of what i use- note the serial number is separated by 'spaces'

regards,

tammy