topic Export Excel in AJAX in QlikView

Export Excel in AJAX

fkeuroglian — Wed, 02 Jul 2014 00:58:43 GMT

In my project for security reason we have uncheck the option to export and print in the qmc, but we have only for 2 user that they can export and print only some objects (not all the object in the document)

I implement some code using macro, but this doesnt work in ajax(only in ieplugin) is there any way to do this using fullbrowser(ajax)

thank you, i will appreciate all the help

Fernando

Re: Export Excel in AJAX

vlad_komarov — Thu, 17 Jul 2014 15:23:27 GMT

Fernando,

This code should work on Ajax (exporting specific chart to the file):

Sub PAExportMem

ActiveDocument.ShowPopup "Please wait...export may take several minutes. File will be saved to Exports folder.", 200

fileVar = ActiveDocument.Variables("vFilenameMem").GetContent.String

fileVar2 = "O:\data_ex\" & fileVar & ".xls"

set objExport = ActiveDocument.GetSheetObject("CH02")

objExport.ExportBiff fileVar2

objExport.ExportEx fileVar2,5

ActiveDocument.GetApplication.MsgBox("Chart Export Completed!")

End sub

Re: Export Excel in AJAX

juleshartley — Fri, 03 Oct 2014 11:21:23 GMT

How does this work on Ajax?...

Re: Export Excel in AJAX

vlad_komarov — Fri, 03 Oct 2014 15:48:36 GMT

Julia,

It works fine in several applications I've developed.
Why you asking?