I suppose a “system.double” variable is a number which is not an integer??Why is this variable not listed in the UPath variables documentation and why is it not a main type of variable?
In fact, I do not understand why System.Double and Generic are not listed as main types of variables…
But anywa… changed to system double type. Still the 1000,00 is pasted as 1000.00
Also, while pasting the System.Double variable into the browser, I still must used variable.TOSTRING, otherwise it says "option STRICT ON doesn´t allow implicit conversions of double to string.
Hi
If you want to type as it is then we can get the value directly from excel as a cell value with READ CELL or READ RANGE and type with TYPE INTO activity within FOR EACH ROW loop
We can validate this either with a writeline activity so that in seeing that we can know how the value is been obtained with its format
edit: it seems I have to install package System.Globalization 4.3.0 to have this CultureInfo activity. However, I am getting an error trying to install this package.
Let’s skip checking the “Culture” of my UiPath and let’s assume it’s set to the wrong “culture”. How do I fix it?
You can try using an assign and set the culture at the start of your workflow.
To should be: System.Globalization.CultureInfo.CurrentCulture
and value should be: New System.Globalization.CultureInfo(“en-US”)
Edit:
As you can see in the screenshot above UiPath will convert the cell value from excel to Double instead of string. Therefore, depending on your Culture the “.” and “,” will mean different things. Hope this helps, theese kinds of problems can be very tricky, to me atleast
As you can see in the screenshot above UiPath will convert the cell value from excel to Double instead of string. Therefore, depending on your Culture the “.” and “,” will mean different things. Hope this helps, theese kinds of problems can be very tricky, to me atleast
When assigning your variable to the data found in the Excel sheet. Check that the Variable Type is set to double.
I tried using “variable” and also “variable.tostring”, in the hopes that adding “tostring” would make it type the text exactly as had been read.
Try this… Write Line = (Convert.ToDouble(variable)).ToString
ok… let’s go by parts. The complexity of variables in UiPath are it’s weakest spot imho.
Let me try to parse your answer…
1 - Change variable to double on variables panel
2 - read cell activity - just read the Excel value and put inside the variable
3 - TypeInto activity: text should be “(Convert.ToDouble(variable)).ToString”
ok, no use doing this. Again, the problem is that when it COPIES from Excel, the variable is already stored as 5555.55 format instead of 5555,55 format. Doesn´t matter if it’s doube or generic or int32.
Maybe I should try copying the variable as STRING and converting it to number when pasting? Maybe copying as text will copy it correctly?