Excel Read Range and Write Range

Help StudioX
, ,
1

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)

read
read1050×577 64 KB

2

@gustavo.souza I think so you need to apply formatting after reading data

3

@gustavo.souza

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

4

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 “,”

5

@gustavo.souza

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

6

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

7

@gustavo.souza

So in locals panel is it giving it proper or no?

Cheers

8

in the locations panel also do not work

9

@gustavo.souza

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

10

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

valores
valores988×214 4.05 KB

11

@gustavo.souza

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

12

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

13

How can I insert the output data table into a data table?

14

@gustavo.souza

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

1 Like
15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.