Export To CSV - Decimal places

[Deepak]

Hi,
      I am trying to set the decimal places in the export to be a customizable setting. I am using the following lines of code

col.ExcelExportType =

 

DisplayFormatType.Currency

 

 

col.ExcelExportFormatString = GetDecimalFormat()

WHere the GetDecimalFormat would return "{0:#.##} for 2 decimal places.

But this snipet does not work. It renders on the csv witht the same number of decimal places as in the data. Are there similar properties for csv as there are for excel?

Thanks
Deepak

[Deepak]

Fixed it using the CSVCellFormatting event.
Explicitly formated the e.csvelement.value to take the configured decimal places

Thanks
Deepak

[Martin Vasilev]

Hello Deepak,

I am glad you have found solution to your requirement. Using the CSVCellFormatting event is the right way to format the result values in exported file. 

Do not hesitate to contact us again if you have any other questions.

Best wishes,
Martin Vasilev
the Telerik team