Don't want to round off value in CSV file

Hi All,

I am facing a problem. When I am appending the value from database to excel CSV the value is automatically round off. I don’t want to round off this value.

Ex: 1,112.000000 round off as 1,112.00
And 289.000000 round off as 289
Please guide me to overcome of this problem. We have thousand of record in DB and want to move in CSV.


Check if the value is in your desired format in your datatable variable before appending to csv.
If the rounding is happening in your excel / .csv you will have to change the format there, i.e. to 6 decimals by creating a template first or changing format after appending.