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

Excel Export in RadPivotGrid ColumnHeader DataFormatString

1 Answer 111 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Jan Skovhus
Top achievements
Rank 1
Jan Skovhus asked on 17 Mar 2014, 10:37 AM
Hey,

Is it possible to format the ColumnHeader to a date format when I export to excel.

If I make a export to excel the ColumnHeader date shows as a number like 41714 and i want it to bee 16-03-2014 00:00:00

Regards Jan

1 Answer, 1 is accepted

Sort by
0
Accepted
Maria Ilieva
Telerik team
answered on 20 Mar 2014, 09:59 AM
Hello Jan,

In order to apply the required functionality you could handle the "RadPivotGrid_PivotGridBiffExporting" event, access the Header Cell and apply the needed value. Similar approach is presented in the online demo below:
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/exporting/defaultcs.aspx

Regards,
Maria Ilieva
Telerik
 

DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges. Watch on demand now.

 
Tags
PivotGrid
Asked by
Jan Skovhus
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Share this question
or