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

: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 11 is stored in the cell.I have the code below for reading the value but result is empty string. RCell

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

- 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

[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 11 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

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

Try to validate the cell that you read... Str GetCellValue(sysExcelCell RCell) { Str CellValue; Int IntegerValue; ; switch(RCell.value().variantType()) { case COMVariantType::VT_R4 : IntegerValue= any2int(RCell.value().float()); CellValue =