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

Changing column format in Export to CSV

1 Answer 431 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Waseem
Top achievements
Rank 1
Waseem asked on 23 Jan 2013, 03:15 PM
Hi,
Could please anyone tell me how I can change a column format in Export to CSV. In my grid I have some columns where I am displaying date as text. On Export to Excel it shows the date (as text) exactly as it is in the grid (23 jan 2013) but when I do the Export to CSV it changes the text type date to a different formt (23-jan-13). Could please anyone tell me how I can change the Export to CSV format so than I can display my date text same as Export to Excel format which is 23 jan 2013.
Regards,  

1 Answer, 1 is accepted

Sort by
0
Accepted
Kostadin
Telerik team
answered on 28 Jan 2013, 09:16 AM
Hi Waseem,

Note that CSV export format is based on a plain text and you could not format it as you may format Excel or Word. In your case the DateTime column is formatted by the program itself (for instance Excel). If you open the csv file with a simple text editor (for instance Notepad) you will see that the DateTime column has exactly the same format as the one in the grid.

Regards,
Kostadin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Waseem
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or