Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Macro to export tables to excel

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

5 Replies
erikadvectas
Valued Contributor

Re: Macro to export tables to excel

Hi Ramkunar,

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

Regards,

Erik

jean-philippe
New Contributor II

Re: Macro to export tables to excel

Hi Ramkumar,

Do you have this parameters below ?

Requestred Module Security = System Access

Current Local Security = Allow System Access.

System Access.jpg

Best regards,

Jean-Philippe.

vadimtsushko
Contributor III

Re: Macro to export tables to excel

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

Not applicable

Re: Macro to export tables to excel

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

vadimtsushko
Contributor III

Re: Macro to export tables to excel

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.

Community Browser