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

How to format date column while exporting data to excel

1 Answer 138 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Chirag
Top achievements
Rank 1
Chirag asked on 27 Apr 2011, 03:10 PM
Hi,

We are using radgrid(RadGrid.Net2, Version=5.0.1.0) and we are exporting data to excel using radGrid.MasterTableView.ExportToExcel();
As grid contains date columns, we want to format it in given format. But grid does not support "ExcelExportCellFormatting" event.
Can anybody provide me the solution or any workaround.

Reg,
Chirag

1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 27 Apr 2011, 03:44 PM
Hello Chirag,

You can apply custom formatting as explained in the RadGrid formatting and PDF export section in the following help topic.
Exporting tips and tricks

Note that the aforementioned control is no longer supported. I strongly recommend that you upgrade your controls.

Regards,
Daniel
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
Grid
Asked by
Chirag
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Share this question
or