c# - Reading exponential values from excel file result in loosing data -

c# - Reading exponential values from excel file result in loosing data -

i reading xls file using oledb connection string

mcon.connectionstring = ("provider=microsoft.ace.oledb.12.0;data source=" + mstrfilepath + ";extended properties=\"excel 12.0 xml;hdr=no;imex=1\"");

i have deliberately set imex = 1, can read values text xls sheet contains mix info type.

now in xls sheet there columns contains exponential values eg 4.0416e+14 has internal value 404160301389870. problem when read xls, reads exponential values instead of internal value, causing lose of data. how can solve problem. please suggest !!!

c# excel winforms oledb