Export to Excel like title bar, but with button (and on Ajax)

[#1]

My design team doesn't want to have the icon to export to excel in the title bar of a chart, but still wants the functionality to export the contents of the chart (it's a straight-table chart) to excel.  I've created a simple button with a macro that exports to excel, which works fine on the normal client, but will not work with Ajax.  However, I can see that if I did have an excel button in the title bar of a chart, it exports both on the thick client and on the web (It's a download, but I get a spreadsheet - that's what I want).

Most posts I've read has macros that won't work on Ajax.   Is there any way to get the title bar export functionality by using my own pretty button (with actions or a macro)?

Thanks.

[#2]

I've got the exact same challenge just now - we cannot utilise the IE Plugin, which would in essence allow for macro functionality, so I'm in the same boat of trying to get a button with a macro to fire within AJAX.

There's a way of doing it via the info in the link below, but my IT dept isn't keen on the implementation of this as it requires changes to ISAPI and CGI restrictions etc - so I'm now looking at other methods..namely trying to get a trigger to fire a batch script using the URL option when a condition is met (flag change)...not there yet, but I'll get it !

Finally, I'm also looking at what the Send to Excel option actually does when you right click - the links all seem the same, aside from the GUID as the object/filename that opens as csv/xls - so I'm looking to see if it's an object guid etc - if it is, I may be able to use the URL and a trigger to force it to export...

Sorry for the ramble, but I feel your pain !

https://qvextcalledxfromajax.codeplex.com/

[bgerchikov]

Hi,

I'm wondering whether you used Action/Export functionality on Ajax.

Please review attached

Thanks!

[#4]

I saw the export action, but that seems to just be fore exporting fields.  I have a chart that has had set analysis applied to it, and want to export the contents of the chart, not just dumping fields from the internal tables.  If the export action allows for that type of functionality, I would certainly use it!

[jerrysvensson]

Have a look at ServerSideExportEx API function.