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

RadGrid Export DateTime Format

4 Answers 151 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Keshav
Top achievements
Rank 1
Keshav asked on 18 May 2015, 04:53 AM

Hi All,

 

I have a radgrid which has DateTimeColumn with format as "dd-MMM-yyyy HH:MM:SS AM/PM" (eg - 18-May-2015 10:20:45 AM).

I want the format to be same when exported to excel.
Please help.

 NB - I donot want to use export fomat as 'Biff'

 

Best Regards ,

Anurag

4 Answers, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 20 May 2015, 10:47 AM
Hello Anurag,

Could you please let me know which export format you are currently using? In case you are using the default format I would recommend you to examine the following help article which elaborates more on applying a custom format.

Regards,
Kostadin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Keshav
Top achievements
Rank 1
answered on 20 May 2015, 11:09 AM

Hi Kostadin ,

I am using default format. I had already tried the help article but in vain.

I am not able retain datetime format in exported files.Is there any alternative ?

I have attached snaps. 

 

0
Keshav
Top achievements
Rank 1
answered on 25 May 2015, 06:23 AM

Hi All,

Can anyone suggest me a solution. I need it asap.

Regards,

Anurag

0
Kostadin
Telerik team
answered on 25 May 2015, 07:11 AM
Hello Anurag,

Please try using the following format and let me know about the result.
e.Cell.Style["mso-number-format"] = @"dd\-MMM\-dd\ hh\:mm\:ss\ AM\/PM";

Regards,
Kostadin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Grid
Asked by
Keshav
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Keshav
Top achievements
Rank 1
Share this question
or