View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
latha latha is offline
external usenet poster
 
Posts: 3
Default determinig datatype in excel

Hi
I am using aso.net 2005 with excel with the following settings

rk.SetValue("ImportMixedTypes", "Text");
rk.SetValue("TypeGuessRows", 0);
Imex=1
HDR=Yes

I am having problem when reading "2012101", it is converting into
"2.01214e+006" automatically.
I do not want this conversion and at the same time, i cannot format
someone's excel sheet.

Can someone tell me how to read data as it is?
--
Thanks
Soly