Convert Column to Text

Help
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:

1 Like
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!

1 Like
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!

1 Like
7

I finally got it. Many thanks.

1 Like
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 ?

Capture
Capture1920Ă—706 25.8 KB

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

Capture
Capture1076Ă—521 8.04 KB
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 !!

18