Convert exponential values in excel to numbers

[rpatil (Raj)]

Hi Guys,
I need help in obtaining the datatype of an excel field
and then convert it to a string

[Palaniyappan (Palaniyappan P)]

Kindly have a view on this thread

Excel operation

[excel] I have an input file with card information, while reading the file it is showing like this “4.05E+15” I tried "format cells " in excel file and executed the code . Even after that I am not getting the exact card number. Is there any option to convert the vlookup code to normal value in Uipath ?

Cheers @rpatil

[AshwinS2 (Ashwin S)]

Hi @rpatil

use row (“ColumName”).ToString.expression=Integer.Parse(row(“ColumnName”).ToString,System.Globalization.NumberStyles.Any))

Check this

Thanks
Ashwin S