Excel operation

Help
1

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 ?

2

Hi @hemanth_chinna

Just check it on google and got the below to convert scientific notation to numbers.

https://www.extendoffice.com/documents/excel/1725-excel-convert-scientific-notation-to-text.html

Try this way.

If not then attached xaml for reference. Just gave a try to convert the same in numbers as required.

Excel_Operations.xaml (9.0 KB)

Regards,
Ashish

2 Likes
3

Thank you so much for the solution, can you please help me how to split the card number(16 digits) in to 4 parts and assign each part in one variable?

4

this isssue is solved by Split number into different parts