Convert Column to Text


#1

How do I convert exponential form to text form using uipath ? For example, 3.58232783E+15 in a data column to 358232783405688420? Thank You


#2

Hello @Lim_Jia_An,

I hope this helps :slight_smile:


#3

Thanks for the reply. However, i am having an error below. May I know Why? Thanks

Source: Read range

Message: The process cannot access the file because it is being used by another process.

Exception Type: IOException


#4

Are you using two excel activities in the workflow?

If not simply open the excel once and close it again manually… it might not have closed properly!


#5

I have restart my computer and open the file again and i got the same error. I guess the problem is within the code. I will look into it. Thanks.


#6

Make sure your excel file isn’t open while your robot it running!


#7

I finally got it. Many thanks.


#8

Do mark it as a solution if this was helpful!
:slight_smile:

Happy Automation!


#9

Sorry to bother you again. Although i got the strings of numbers i want. However, when i write cell on B8. It turn outs to be the same. May I know the reason why ?


#10

The message box got the number i want. However, when i write into the cell is different


#11

Can you please show me your workflow?
Would be even better if you could upload it.


#12

This is the file. Thank You
Excel_Operations.xaml (10.4 KB)


#14

@Lim_Jia_An

In write cell activity put
“’” + varCardNumber ,that is preceed your number with single quote! that’ll make excel recognise it as text!

Let me know if it works!


#15

Hi Sir,

It is still the same.

It is still the same

Capture2


#16

@Lim_Jia_An
You have to put ’ between the double quotes!
" ’ " ,spaces are only to make you understand,do not give spaces! :slight_smile:


#17

Thank You Sir !!