Re: [Axapta-Knowledge-Village] Cannot read text formatted numbers from excel cell

[arda turkkan]

Thank you all. I solve the problem by validating the CellValue.

kbi kbi <[EMAIL PROTECTED]> wrote:                               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]
 
 
     
                               

       
---------------------------------
 Sent from Yahoo! &#45; a smarter inbox.

[Non-text portions of this message have been removed]