topic Re: Export to Excel in HTML mode in QlikView

Export to Excel in HTML mode

Mon, 29 Dec 2014 14:28:58 GMT

Hello,

I have been ask by a client to enable the pivot table to be export its data to Excel.

I have used the following vbscript (part of it, the most important):

sub exportToExcel_Variant1
Dim aryExport(0,3)
aryExport(0,0) = "CH181"
aryExport(0,1) = "Data Export"
aryExport(0,2) = "A1"
aryExport(0,3) = "data"
Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

In the the development, the button (script) works fine, the problem is when I tested in the web mode it doesnt work.

Can someone help me with this issue please?

Many thanks!!!

Re: Export to Excel in HTML mode

Gysbert_Wassenaar — Mon, 29 Dec 2014 14:47:53 GMT

Macro's with code like that don't work in the ajax client. The server simply cannot execute code on the client.

Re: Export to Excel in HTML mode

Mon, 29 Dec 2014 15:00:04 GMT

Thanks for your help Gysbert,

Do you think would be better use JScript for this task?

Re: Export to Excel in HTML mode

Gysbert_Wassenaar — Mon, 29 Dec 2014 15:02:54 GMT

No, the server cannot execute code on the client. It does not matter if the code is vbscript or javascript.