Convert the value acquired by Excel to Integer

excel

#1

Hi, I’m a Rookie in UiPath and English.

I wanna convert the value read by Excel using [Read Cell] to Integer.
Tryed [Convert.ToInt32] ,but an error was displayed. like this ↓

Message: Input string was not in a correct format.
Source: Assign
Exception Type: FormatException

“5” is entered in the cell.
Please help me…


#2

try Integer.parse(string Value)


#3

If possible do get row item.
Then use this conversion CInt(get row item variable.ToString)


Cannot read a Cell to a variable of GenericValue type
#4

Using(CInt(variable.ToString)) solved the problem.

Thanks,all.