Vlookup error : Typeconverter cannot convert from system.string

[KiranBole (Kiran)]

Hello Team,

I am using a simple Vlookup activity in UiPath which is giving below error message :
Typeconverter cannot convert from system.string. Could you please help me.

I tried with variable (created variables), also changed the format in Excel to ensure everything is in same format but none of them has worked. The sample report of my activity is attached herewith.

some more updates now : Vlookup activity works when I downgraded the excel package version 2.20.3 but the question still remain unanswered why such error when using/updating the excel packages to latest version which is 2.22.2

Thanks
vlookupDemo.zip (10.8 KB)

[Anil_G (Anil Gorthi)]

@KiranBole

Mostly the value you are providing is of not same time…can you show your vlookup

cheers

[lrtetala (Lakshman Reddy)]

Hi @KiranBole

Try this

"=VLOOKUP(A2,Sheet1!A:B,2,0)"
Excel.Sheet("Sheet2").Cell("B2")

[KiranBole (Kiran)]

@lrtetala

Thanks for your reply but I don’t want to use Write cell activity as there is a huge amount of data and it takes too long to finish. I have tried this already.

[KiranBole (Kiran)]

Here is the vlookup screenshot

[Shiva_Nikhil]

@KiranBole

you can also try with linq if you want to update the values

i have gone through your xaml its working fine for me

[Anil_G (Anil Gorthi)]

@KiranBole

please use CurrentField.ByField("A").StringValue in value to lookupfield

cheers

[KiranBole (Kiran)]

I tried but still the same error. Even tried variable with string value as well as Generic value but with no luck

[Anil_G (Anil Gorthi)]

@KiranBole

even in save to field you need to add a variable of generic or string type and try please

cheers

[KiranBole (Kiran)]

Thanks for chasing this issue. It looks this error comes only when I’m using latest Excel package 2.22.2 version

[Anil_G (Anil Gorthi)]

@KiranBole

Glad its resolved

Happy Automation

cheers