This is a migrated thread and some comments may be shown as answers.

No ElementExporting when exporting to Excel via RadSpreadsheet

1 Answer 69 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Jay
Top achievements
Rank 1
Jay asked on 11 Jun 2014, 11:19 AM
Hi there,

we have a converter in place hooked up to the ElementExporting event so our CSV export is properly converted.

Using the XlsxFormatProvider and RadSpreadsheet doesn't trigger that event to be fired so our Excel files are not converted.
How can exported values be customized in the RadSpreadsheet context?

Can we somehow use the Html exported by the RadSpreadsheet ?

Cheers,
Jay

1 Answer, 1 is accepted

Sort by
0
Dimitrina
Telerik team
answered on 13 Jun 2014, 08:23 AM
Hi Jay,

The ElementExporting event will be raised if you invoke RadGridView.Export method. If this method is not used to export the data, then the event will not be fired.

I can suggest you one alternative solution exporting with ExportFormat.Html and using HtmlFormatProvider. 
You can find a demo solution attached. That way the ElementExporting event will be raised.

Regards,
Didie
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
Tags
GridView
Asked by
Jay
Top achievements
Rank 1
Answers by
Dimitrina
Telerik team
Share this question
or