read text file from excel

bangswit Member Posts: 265

2010-09-20 edited 2010-09-20 in NAV/Navision Classic Client

hi all, i have document no = 12345
but in excel buffer it is 12,345
how to make it become 12345
my code is like this (failed)

EBDoc.RESET;
EBDoc.SETRANGE(EBDoc."Row No.",RowNo);
EBDoc.SETRANGE(EBDoc."Column No.",11);
IF EBDoc.FIND('-') THEN
PL."Document No.":=FORMAT(EBDoc."Cell Value as Text");
PL.VALIDATE(PL."Document No.");

0

Answers

• 

  Hanen Member Posts: 281

  2010-09-20

  Hi,
  
  you should read the cell value and eliminate the "," SOMETHING LIKE SUBSTR

  Regards
  
  Hanen TALBI

  0
• 

  rhpnt Member Posts: 688

  2010-09-20

  Check the cell format of your Excell sheet (it should be text) and the value of the field.

  0
• 

  bangswit Member Posts: 265

  2010-09-20

  rhpnt wrote:

  Check the cell format of your Excell sheet (it should be text) and the value of the field.

  yes
  that's right
  i chance the excel file and it works
  thanks

  0