Loading

Exporting a datatable to csv format

priya priya

17y7.5k.NET

Hi,

I'm importing a datatable into a csv format ,and i am giving the phonenumber as 20000000000000000090456527365 and this value after exporting to csv format in the excel file it shows that value as 2E+28.But i want that number as 20000000000000000090456527365 in the excel sheet.
please help me to overcome this problem.

Thanks in advance

2E+28

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Master Billa17y ago
Hi

Yes when you are export data in 20000000000000543434 no, excel sheet take as number and it's add exponent value.

so you need handle in using this code

http://www.codeproject.com/KB/aspnet/ExportClassLibrary.aspx

thank you