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

Export to excel not showing datetime cells correctly

1 Answer 72 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mak
Top achievements
Rank 1
Mak asked on 20 Mar 2009, 12:16 PM
Hi, we currently use the ExporttoExcel method to store our grid data into an excel spreadsheet. A problem has arisen in the latest rad controls which results in (SOME) of our datetime cells being formatted differently to the others, they are all stored in exactly the same format in the database but yet when they are exported to excel they appear in this way

                                        05/05/2008 15:10
                                        05/05/2008 10:23
                                        05/02/2008 15:39
4/30/2008 1:58:05 PM
4/30/2008 1:51:39 PM
4/30/2008 1:30:42 PM

not only is the datetime format different, the cells are aligned different too.

Hope you may be of assistance!
Looking forward to your reply

1 Answer, 1 is accepted

Sort by
0
Mak
Top achievements
Rank 1
answered on 20 Mar 2009, 12:52 PM
Hi my bad, i meant it for ASP.NET grids, not AJAX

please close, sorry
Tags
Grid
Asked by
Mak
Top achievements
Rank 1
Answers by
Mak
Top achievements
Rank 1
Share this question
or