Hi everyone, I am new to UiPath. Now i’m stuck with my task which is i have to multiply between two column in the same excel file. The problem now, its throwing an error “Cannot convert Generic value to System.Int32”. I’m not sure my variable that i use correct or not. There are similar problem like…

thanks. already solved. Instead of skip row, i put if condition IsNumeric(variable). its working now. Thank you guys :slightly_smiling_face:

Hi @isyahhamid , Convert the value to Integer and try again. Ex: Convert.ToInt32(yourGenericVariable) Regards, Arivu

when i try to get my value, it start with column name [image] this is because my data in excel start in third row. Can anyone help? Thanks

you can try: Cint(usage_value.ToString) * Cint(issue6_value.ToString) Can you tell me why you have a Generic type value? is your variable defined as that type? If you are getting a string type you can directly set the variable type to string.

hy, Can’t you change the type of your variable, int32 or String (not GenericValue) ?

for your index to start at 3 you can check below thread: [image] Make for each row start at specific row in datatable Help Hi there Im trying to make an for each row start at a specifik row in the datatable. I have the entire flowinside a try/catch - and after an error i …

Cannot convert Generic Value to System.Int32

Help

nadim.warsi (Nadim Warsi) February 22, 2019, 8:57am 7

for your index to start at 3 you can check below thread:

Topic		Replies	Views
Cannot read a Cell to a variable of GenericValue type Help excel , activities	8	3642	August 8, 2017
Error : convert generic value to int32 Activities excel , activities , question	4	640	July 8, 2021
Convert Generic Value to Int32 Help studio , variable	29	30746	October 29, 2018
Cannot convert Excel Value to System.Int32 StudioX studiox , question	8	3368	October 10, 2021
System Error - not working as expected for Cint conversion Help excel , studio , error	14	3084	November 23, 2019

Cannot convert Generic Value to System.Int32

Related topics