Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ajax 'send to excel' Button

Is it possible, within the ajax client, to create a button that will send a chart to excel?  So far from my experience you can only create macros that send objects to excel with the IE Plugin.

It would seem possible because the button on top of the charts works fine, unfortuanitally I need this functionality from a button. 

11 Replies
Brett_Bleess
Former Employee
Former Employee

Correct the ID is 45241, but you can try the html format instead:

sub HTML
set tb = ActiveDocument.GetSheetObject("TB01")
tb.ServerSideExportEX "C:\test.html" , ";" , 0
end sub

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Brett_Bleess
Former Employee
Former Employee

The only problem with the above is the code/process to get the file from the server to the client, which you will need to write.  Regarding things in IE that can block things, the Enable Protected Mode setting is most off the culprit in these cases, so you can be sure your QVServer site is in Local Intranet or Trusted Sites Security Zones, as those should have it disabled by default.  Other than that, I would recommend you use Fiddler to trace things, as that will likely give you a better indication as to where things are getting stuck, or you can simply try the F12 Developer Tools option in IE as well, as that may work as well.

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.