Convert text column to number in uipath

i have lookup the column with text format due to text format i am unable to calculate with assign activity kindly define how to convert column to numeric



try this with place it in the string variable


You can add this package:

It has a ‘Change Data Type’ activity which can convert the Column Type.

1 Like

Hi @Sheikh_Mustafa ,
some ways to convert type of columns
1.You can try by activity
open file send hot key win+r to open run
type into file path
send hot key enter to open
click column need change type
click type, type into name of type
send hot key enter
send hot key ctrl+s
to save file
2. you can find invoke vba code