I’m new to UiPath and I’m trying to update the Status column in gsheet based on whether or not approval is made. Please see SS whether I’m stuck [image] Here’s the code I’ve Result_from_Read_Range.Select(String.Format(“Sno = {0}”, CurrentRow(“sno”).ToString)).FirstOrDefault Please assist.

@Kumaresan_Boopathy I believe you copy pasted the code exactly…please remove inverted comma and add again in the advanced editor window Correct - " Wrong - ” Cheerd

Cannot perform operation on system.string and system.int32

Help Studio

Anil_G (Anil Gorthi) July 3, 2023, 7:36am 8

@Kumaresan_Boopathy

It looks like the excel process issue…

May be the excel is locked as you are using in loop or so

cheers

Topic		Replies	Views
About uipath studio on excel and datatables Help excel , activities , studio	3	1079	June 27, 2018
Sum rows from different excel sheets if value matches and assign it to third column Help datatable , excel , uiautomation , activities	19	1378	February 13, 2020
Column does not belong to table Help	37	7132	August 18, 2019
Reading excel and assigning to variables Studio	4	373	September 3, 2023
Rewrite certain values in existing excel Help	14	1213	August 26, 2019

Cannot perform operation on system.string and system.int32

Related topics