Trouble reading data from excel

[KSK_R_D]

Hi everyone, i’m reading data from 1 column of an excel file and write it to other column of another excel file. The problem is, the data i read from the original column is “0”, but the data written to the output file is 2E-15. I don’t know what happened. Could anyone help me with this please!
Here is the original data

And this is the written output

Both columns are in General format

[vrdabberu (Varunraj Dabberu)]

Hi @KSK_R_D

Are you using Workbook activities or Excel activities.

Regards

[KSK_R_D]

i’m using this

[vrdabberu (Varunraj Dabberu)]

Hi @KSK_R_D

If possible could you share sample excel with dummy data and filter condition. I will check with that.

Regards

[KSK_R_D]

1. TỔNG LƯƠNG (RAW).xlsx (53.2 KB)
2. CC_BD.xlsx (271.5 KB)

[KSK_R_D]

the filter condition i’m using

[KevinE (Kevin)]

It’s a rounding error because of the calculations you are doing with the time. Excel rounds the error down to 0, so you see a 0 in Excel.

If you use the System > File activity, it will keep the error.

If you use the Excel activity, it should round down to 0.

[KSK_R_D]

i understand but, other rows also have 0 value anb the written output gives exactly the number 0
In the original file, each row comes with a formula

I mean, they are all the same from the formula to the cell format, so why don’t it gives the whole wrong output but just some of them

[Yoichi]

Hi,

It seems Floating-point arithmetic matter.
17:00 is 0.708333333333333 and 8:00 is 0.333333333333333 in Excel serial value.
And the result of the formula will be 1.77635683940025E-15 exactly.

It’s same as your output.

Probably it’s reflected when reading it as datatable.
To avoid this problem, can you try either of the following?

• Use “UseExcelFile” activiy and ReadRange for it.

• Modify your formula as the following (Add round function)

Regards,

[KevinE (Kevin)]

Look at the source of those formulas, some of them have 0’s, some of them have more and more formulas. But that is really more of an Excel question than a UiPath question.

If you use the Excel activity, you should get the same Excel value. If you use the System activity, you will have to handle the rounding separately.

[KSK_R_D]

thanks sir, i’ll try it now

[KSK_R_D]

Thanks sir, i tried and it works perfectly

[KSK_R_D]

THANKS EVERYONE SO MUCH FOR SPENDING TIME TO HELP ME. I’M SO APPRECIATE