Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
'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
Hi Ramkunar,
Yes, this might be the reason. Test on a machine where it is installed.
Regards,
Erik
Hi Ramkumar,
Do you have this parameters below ?
Requestred Module Security = System Access
Current Local Security = Allow System Access.
Best regards,
Jean-Philippe.
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
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
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.