Hello my friends, i have a new problem.
I am using the activity Read Range Excel and write range excel, however, the UiPath for some reason is not writing correctly, it is forcing unnecessary formatting
The values read are in this format: 5.0593000
and when written it forces to this: 50593000 (without the comma)
@gustavo.souza I think so you need to apply formatting after reading data
Can you try changing the read formatting to raw value and check
And you mean without dot?
Basically does it represent thousands separator or so?
Cheers
I’ve tried changing it to raw value but it still doesn’t work. This, I mean dot, in my country we use a comma “,”
Then I believe because of the culture differences…the value is being read as a full number instead of counting comma as a decimal separator…
Can you please confirm this…when you read the value …in the locals panel are you seeing it as a decimal value only?
Cheers
I also thought about it, because previously I was performing this RPA on a US machine, but when trying it on my machine (PT-BR) I have the same problem
in the locations panel also do not work
Can you please show how the data is shown in locals panel when you read the data…and please sue display value instead of raw value…then if comma is present to preserve we can try replacing comma with dot and paste it back to let excel understand the difference
and are you doing any manipulations in between? and trying to change that column data?
cheers
Ok, the values are read like this and I need them to stay like this when pasted into another excel. I don’t do any manipulations in between, I just read and write
Can you please show the data after reading how it looks in the locals panel…when ruinning in debug…do a step into and after reading open locals panel and show the data
Also if you are only reading and writing can you try using copy sheet instead?
cheers
Sorry for the delay, I was just thinking of a solution.
I’m trying the following: I read the Excel data using “Read Range” with the output: “CargaPTX2”
So I use Output Data to transform the data I got into a String, but I don’t know how I can write the Output Data Table output in an excel
How can I insert the output data table into a data table?
output datatable converts datatable to string…you cannot write as datatable
the solution should be to change the column type to string or else
cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
