Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a button to export chart to excel in AJAX

Hi,

How do I replicate the behaviour of the XL button top right hand corner of a chart object into a nice big button that the users cannot miss? The app will have to be public web facing and AJAX so I would imagine I would be limited with Macros. I can print via actions but not export to excel, very frustrating?

TIA,

Jane

Labels (1)
8 Replies
Not applicable
Author

I would like to know this too! Insight would be appreciated.

Not applicable
Author

Hello,

i have actually the same problem.

Did you find a solution ?

Kindly,

Not applicable
Author

Sorry, no solution.

Jane [:'(]

Not applicable
Author

Hi,

sub SendToExcel(UID)

set obj=ActiveDocument.getSheetObject(UID)

obj.SendToExcel

end sub



where UID is the ID of the Object you want to ewport to Excel

Hope this help 🙂

HD

Not applicable
Author

Hello Hannen,

your solution only works if using IE Pluggin, but not with Ajax.

Thank you anyway ;-))

Not applicable
Author

Hi,

Within the button action items you can chose to either save to a clipboard and then paste into Excel, or save to a csv file which could be opened in Excel ...

Not 100% sure about using that with the Ajax version, but it's not using a macro so hopefully should be ok.

Cheers,

Emma

Not applicable
Author

Anyone find a solution to this?

Not applicable
Author

I have the same requiremnent , so if anyone has a solution to this problem i would very much appreciate if you could share it with me.

Thanks

Graham