topic Macro to export tables to excel in QlikView

Macro to export tables to excel

Mon, 26 Jan 2026 18:19:17 GMT

This line gives error

set XlApp = CreateObject("Excel.Application")

'ActiveX' component can't create object:'Excel.Application' error on IE

The settings are all fine at the module level and at the document level (Server tab).

One point to note is i am developing directly on the qlikview server and it doesn't have excel installed. Could this be the reason?

Thanks

Ram

Re: Macro to export tables to excel

ergustafsson — Fri, 25 Jul 2014 11:22:07 GMT

Hi Ramkunar,

Yes, this might be the reason. Test on a machine where it is installed.

Regards,

Erik

Re: Macro to export tables to excel

Jean-Philippe — Fri, 25 Jul 2014 11:58:05 GMT

Hi Ramkumar,

Do you have this parameters below ?

Requestred Module Security = System Access

Current Local Security = Allow System Access.

Best regards,

Jean-Philippe.

Re: Macro to export tables to excel

vadimtsushko — Fri, 25 Jul 2014 11:59:08 GMT

Hi Ramkunar.

Note that if you want just export chart to excel without any sophisticated preprocessing (if you basically have to emulate context menu command `Send to Excel`) - you can do it without having Excel installed.

Use `exportBiff` method, something like:

set chart = doc.GetSheetObject("CH01")
chart.ExportBiff("AbsolutePathToFile.xls"))

Regards, Vadim

Re: Macro to export tables to excel

Tue, 29 Jul 2014 03:37:00 GMT

Hi, exportbiff works at server without the excel installed. But my requirement is to export multiple charts into respective sheets in the same excel file. Is that something achievable using exportbiff? I looked around but can't find anything useful.

Thanks,

Ram

Re: Macro to export tables to excel

vadimtsushko — Tue, 29 Jul 2014 14:12:53 GMT

I believe exportbiff exports only one chart to one excel file. So if it is crucial requirement for you, you stuck with Excel automation method. That implies you need have Excel installed.