Get Particular Cell Range In Google Sheets

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Hi,

Input - I want to get the cell range of Hyderabad.

Output - B2

Here i was using google sheets using gsuite activities with out lookup range is there any alternative approach…? If So please suggest

Thanks,
Rishi

[Anil_G (Anil Gorthi)]

@Putta_Sri_Sai_Rishik_Chow

How To Integrate Google Chats With UiPath

@Putta_Sri_Sai_Rishik_Chow Welcome to the community I guess this is where you would find help…then you can use webapi http request activity to hit these end points Cheers

[Yoichi]

HI,

How about using ReadRange, then get addresses from the datatable, as the following?

addresses = dt.AsEnumerable.SelectMany(Function(r,i) r.ItemArray.Select(Function(o,j) Tuple.Create(o.ToString,j)).Where(Function(t) t.item1=searchString).Select(Function(t) UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(t.item2+1)+(i+2).ToString)).ToArray

note: addresses is String array type.

Regards,

[Gangadhar_Athili]

Str_Location = “hyderabad”

“B”+(DT.Asenumerable.Tolist.FindIndex(Function(r) r(“place”).Tostring.Tolower=Str_Location)+2).Tostring