Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Tags (4)
Labels (1)
8 Replies
Not applicable

Create a button to export chart to excel in AJAX

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

Not applicable

Re. :Create a button to export chart to excel in AJAX

Hello,

i have actually the same problem.

Did you find a solution ?

Kindly,

Not applicable

Re. :Create a button to export chart to excel in AJAX

Sorry, no solution.

Jane [:'(]

Not applicable

Re. :Create a button to export chart to excel in AJAX

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 Smiley Happy

HD

Not applicable

Re. :Re: Re. :Create a button to export chart to excel in AJAX

Hello Hannen,

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

Thank you anyway ;-))

Not applicable

Re. :Re: Re. :Create a button to export chart to excel in AJAX

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

Re. :Re: Re. :Create a button to export chart to excel in AJAX

Anyone find a solution to this?

Not applicable

Re. :Create a button to export chart to excel in AJAX

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