Cannot convert Excel Value to System.Int32

Help StudioX
,
1

image
image1920Ă—1080 205 KB

Hi,

I am doing a project for my university project which reads the excel file and uses vlookup and gets the result out but i am facing a problem in running it.

At first i was doing on studioX but some solutions were to change the variable to int32, so i changed from studioX to studio and changed the variables but still not working.

Could somebody help me out?

2

Hello @m.jazib

Welcome to UiPath Community.

Did you try converting the Int value to the respective Datatype (say String)

If still facing issue, would you be able to share your workflow ?

Thanks,
Jeshwanth

3

Hey @m.jazib

Can you try the below steps,

  1. Clear the existing variable “ADD”
  2. Create a variable in the Output Field. (ctrl + K). So the variable will be created of the same type by default.

Regards,
Goutham

4

@jeshwanthaloy here is the workflow section where i am facing the issue :-

image
image1120Ă—873 25.8 KB

so, basically what i want to do is get the ID from user and check the excel sheet for the ID and print its address.

@GouthamVijay I did try the steps you suggested but still gives out the same error

image
image1232Ă—654 23.9 KB

image
image722Ă—526 31.2 KB

5

Thanks @m.jazib

Can you retry by changing both ADD and AUD to String ?

Thanks,
Jeshwanth

6

image
image1109Ă—90 4.54 KB

tried already, still same

7

Can you try the below ?

image
image750Ă—1333 286 KB

  1. Get a “Cell Value” as input from the user. Example : A1
  2. Pass the same to Value to lookup
  3. In range click Excel → Indicate in Excel and indicate the whole range
  4. Column Index must be the column number. Example : if you need to lookup to the column A, then then value should be 1.
  5. Save the value to OutputVariable.

This works !

Please try and mark this as solution if its all good.

Happy automation. Thanks !!

8

Hi ,
The value can be opened in the Advanced Editor in which convert the value from Saved.values(Of ExcelValue) variablename to Saved.values(Of Int2) variablename