it seems like the the value in excel is considered as a double value; please
try value().double
Or you can try format it as a text.
hope this help
Khue
----- Original Message ----
From: turkkanarda <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Saturday, February 2, 2008 2:32:26 AM
Subject: [Axapta-Knowledge-Village] Cannot read text formatted numbers from
excel cell
Hi all;
I have a problem about reading from excel cell.Cell format is text and
"1111111111" is stored in the cell.I have the code below for reading
the value but result is empty string.
RCell = Cells.Item(i, 1);
string = RCell.value( ).bStr();
I can read double or int values succesfully but can not read text
formatted numbers.
if i change the cell value into "a" , this time i can read it from the
cell.
Regards;
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
