Numer formatted as text in cell

Help Studio
1

Screenshot (1)
Screenshot (1)1314×672 52.3 KB

Hello Guys,

i need your help. When I extract data from a pdf into excel the output number is formatted as a text in the cell. I need to change it into a number as attached in the screenshot.
Is it possible to automate it in UiPath? Or is there any step where I have to change from “string” to “int32” ?
Thank you in advance

2

@m.g95 Can you try using this Activity :

  1. Read the Excel File as a Datatable.

  2. Use the Activity mentioned above to change the Type of the Column.

  3. Write it back to the Excel File (Separate File for Checking) using Write Range.

Check the File if it is Updated or not.

1 Like
3

Thank you @supermanPunch,

my problem now is that the Object reference was not set to an object instance.

Can you help me with the new issue.

Screenshot (2)
Screenshot (2)1340×683 42.6 KB

4

@m.g95 Have you passed the Datatable to it? And make sure the Datatable is not Empty.

5

Perfect. Thank you. Now it works.

6

Ok there is a new problem because now I need to convert not just normal number like 2. Therefore I used int32.
Now i have to change a number like 19.975,20. Here is the problem that int32 isn’t the right TypeArgument. Do you know which i could use ?

7

@m.g95 Have you tried Double ?

8

Yes I tried System.Double, but that hasn’t worked as well.

9

@m.g95 The numbers will be in the same format ?

10

right… and that’s the problem.