Excel Scope Append range is creating Scientific Notation

Help Activities
, , ,
1

I am using the Excel scope and Append range to update data on an excel sheet,
image

when Bot does this task its putting certain column values in Scientific notation
image

The issue is, I later read this excel into datatable for look ups and matching’s, reading this excel to Datatable result in data being in scientific notation string , instead of real numbers, resulting in not being bale to match these values with original real number values
image

Why is this happening ?, formatting column in excel is not working, i tried format column to numbers , to custom then to zero, these result it adding zeros at the end and changing some of the ending numbers (maybe rounding it)
image

Is there a uipath solution so the append range wont get entered in scientific notation ? its a type string also

image
image476×591 16 KB

2

@Jay_Chacko - As you know , this is excel problem or uipath problem , please refer the link below see which method works for you…

https://www.logicbroker.com/excel-scientific-notation-disable-prevent/

I would suggest adding an ’ infront of your data would work.

2 Likes
3

thanks this works perfectly

4

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