How to stop data round off while writing data into an excel file?

Help Activities
,
1

I have a scenario where i have to write data into an excel file but when i am using excel activities data is getting round off and decimal values are also getting removed.

Workbook activity are working fine for this scenario but I need to read sheets also.
And I couldn’t find any activity in workbook to read sheet.

2

Hi,

Can you share your workflow and worksheet?
It might be caused by format style of the target cell.

Regards,

3

@harshikakhatri269 please check your excel format.

4

Hello @harshikakhatri269 , Welcome to Uipath community.
If you are writing data in decimal, then pass the value in System.Double variable, other wise it will round of your values.
To convert your string into System.Double Use YourDouble=CDbi(YourString)
Note : YourDouble is variable type of “Syste,.Double”
image

image
image749×190 9.24 KB

image
image742×365 15.8 KB

If It pass in integer, Value will round off

image
image734×341 15.4 KB

5

Thanks for replying cell format was general when i was writing data into excel.

Apologies for replying late.