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
0
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
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
Hello Anurag,
Please try using the following format and let me know about the result.
Regards,
Kostadin
Telerik
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