How to read the decimal 0(zero) in excel?

Hi All,

I need to read a value from the cell from the excel which is as below:

image

12345.10 this is the actual value but when I read using the UiPath its showing as 12345.1

can anyone please suggest me that how can I read the amount value with decimal which contains 0.
i.e. I need 12345.10 but not 12345.1

please suggest me on this

Hi @naveen.s

you can use normal excel application scope activity along with read cell activity with enabling the option preserve format in properties
image
image
hope it helps!!!

Same thing to be added to the queue as well

@Baskar_Gurumoorthy

Hi @naveen.s

=> Read Cell Workbook


Output-> variable(DataType: System.String)

=> Use Add Queue Item activity. Give your queue name and in item Information give like below:

Output after adding to the queue:

Regards

1 Like

if you are going to add bulk items , you can use read range then pass the output data table to queue using "BULK ADD QUEUE ITEM’ Activity
image
instead adding single item you can use this activity, if you want to add specific item from sheet you can use filter data table activity then you can use bulk add queue item activity.

1 Like

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