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

Export to CSV in Telerik Report

1 Answer 125 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Basanth
Top achievements
Rank 1
Basanth asked on 29 Apr 2010, 11:18 AM
Hai All,

I have a date column in my report.While i was exporting to csv or excel file date column is not displaying the date it is showing "#######" symbols instead of date.

Please any one can give me the solutions.


Thanks
Basanth

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 04 May 2010, 06:58 PM
Hi Basanth,

The Comma-Separated Value (CSV) rendering extension renders reports in comma-delimited plain text files, without any formatting. It uses a string character delimiter to separate fields (, - comma) and rows (<cr><lf>). The resulting file can be opened in a spreadsheet program like Microsoft Excel or used as an import format for other programs. The exported report becomes a .csv file and returns a MIME type of text/plain.

The # symbols in Excel replace the data when the space in the cell is not sufficient to display all the data.

To avoid this behavior our suggestion would be to directly export the reports to Excel. If this is not an option, please check out the How to get of rid of #### symbols in my Excel worksheet article.

All the best,
Peter
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
Basanth
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or