mahima jain
Top achievements
Rank 1
Rank 1
mahima jain
asked on 13 May 2011, 01:46 PM
Hi all,
i am facing issue in exporting griddata to excel . i have a grid which has column of datetimetype where datetime is in 12 hr format ... when i export this grid data in excel and open excel it shows grid this column's value in 24 hr format . I also attached excel file for reference ... in grid i have datetime as 5/4/2011 1:18:03 PM but in exported excel file it is in 5/4/2011 13:18:03 when i click on this cell it shows me in 12 hr format but my requirement is it will be in 5/4/2011 1:18:03 PM only .... i can customize my column excel but thats not feasable beacuse every time i export i need to customize it ... Kindly look into the issue ASAP .
i am facing issue in exporting griddata to excel . i have a grid which has column of datetimetype where datetime is in 12 hr format ... when i export this grid data in excel and open excel it shows grid this column's value in 24 hr format . I also attached excel file for reference ... in grid i have datetime as 5/4/2011 1:18:03 PM but in exported excel file it is in 5/4/2011 13:18:03 when i click on this cell it shows me in 12 hr format but my requirement is it will be in 5/4/2011 1:18:03 PM only .... i can customize my column excel but thats not feasable beacuse every time i export i need to customize it ... Kindly look into the issue ASAP .
1 Answer, 1 is accepted
0
Hello Mahima,
You can set the date format manually as explained in the following topics:
Word/Excel export (HTML-based)
ExcelML basics
Let me know if you need more information.
Kind regards,
Daniel
the Telerik team
You can set the date format manually as explained in the following topics:
Word/Excel export (HTML-based)
ExcelML basics
Let me know if you need more information.
Kind 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.