Problem with lookup Datatable activity: Lookup Data Table: Wrong variable type assigned to 'Found Cell Value'. It is 'System.String' but it should be 'System.Object'

Help Studio
,
1

i am making a lookup on the datatable the value is found but throw this error: Lookup Data Table: Wrong variable type assigned to ‘Found Cell Value’. It is ‘System.String’ but it should be ‘System.Object’

2

Hi,

Can you try to set object type variable at Output-CellValue? Because datatype of the target column is object type, i guess.

image
image356×503 17.4 KB

Regards,

1 Like
3

Hi @luchovelez

That’s weird, cellValue property returns a String Type variable, could you try removing the variable and the press ctrl + k and create a new one? maybe it could be a bug or something like that

if the above dont work then try upgrading/downgrading your dependecies

Regards!

4

Hi @luchovelez , i have this problem all of a sudden, it was working previously. Could you please tell me how you solve this problem ?

5

Hi @Hara_Gopal,

Delete the variable, click a different activity, click the Lookup activity again, and try to recreate the variable using CTRL+K in the placeholder of CellValue. It should work.

Regards,
Ranjith Udayakumar

6

@ranjith_udayakumar , not really, there seems to be a problem with the new Excel Version : 2.23.25. I have downgraded the version and it worked …

1 Like