import from excel to progress, number in excel should be char in Progress

[karl.dorme]

I am trying to import some files from excel to progress

assign charfieldname=string(handelworksheet:range(A1):value) no-error.

The cell A1 in excel contains 100.
Now,
When I execute the above command, the fieldname file contains
100,0000000 i.o. 100 .....
How can I solve this problem

I have already changed then cell-format in excel to text, but without any result. :blue:


Thanks for a quick answer !!! :awink:

Karl Dorme
TVH Forklift Parts
Belgium

 

[mjpowellesq]

How do U know that the value = 100,0000000 ???
In Progress the value is assigned to a variable, the variable is then displayed
with an appropriate format.
When assigning the Progress var tell it what format U would like assigning.
Work around assign the value to local var to get the data locally. Then assign the local var
to another var with the format U require

 

[tamhas]

Is this an issue of using , for a decimal point vs . ?

 

[Rob Fitzpatrick]

Be careful on the Excel side as well. As with ABL, the value you see displayed isn't always the value that is stored.

And I agree, it probably is a case a of number format issue (comma versus period).

 

[rzr]

q was posted on 3'dec-2001. I'm hoping the OP has'nt been waiting for this past decade.. .. boa noite..

 

[mrobles]

Before the load put this in your code:

SESSION:SET-NUMERIC-FORMAT(",",".").