Export gridview to csv

Question

I am trying export gridview to csv.

• I am adding actual record into cell of excel not trying html to excel.
• I am executing sp, taking record into datatable.
• Looping through datatable, writing into file using streamwriter.

But problem occur when my column has long number, csv shows 890+32 like this.

I don't want like this, want actual number like 89012345676898899998776766544333445556677.

How to do that? I am not using Gridview.RenderControl(htmltextwrtter).

Answer 1

Try to cast the number into a String and add a leading ' to force excel to see the entry as text, like this:

'89012345676898899998776766544333445556677

Otherwise excel will see them as numbers (which they are, of course) and auto-format them in the unwanted format.