Export to CSV in Telerik Report

[Basanth]

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

[Peter]

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.