Excel cell value extraction - issue

Hi… I some issue in retrieving a value from Excel . The cell value (0.00) of Column “Difference” is calculated by Column A - Column B. When I read the cell value of Column “Difference”, I get the result as -2.80514359474182E-06 instead of 0. Can anyone let me know why this is happening?

image

image

Thanks

Hi… I found the issue. The datatype of cell was double. I changed the format to int32 and it resolved the issue

Thanks

2 Likes

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