Hi,
Is there a way in UiPath to locate a specific value in an Excel sheet and return the cell address (e.g., A5, C10) without using the Find/Replace activity?
For example, if the sheet contains the value “Order123”, I want UiPath to quickly identify which cell contains it.
Is there any faster or more efficient approach to achieve this?
Use Read Range and store data in dt (DataTable).
Use below linq , this will store output in cellAddress. This is the fastest.
(From r In dt.AsEnumerable()
From c In dt.Columns.Cast(Of DataColumn)()
Where r(c).ToString.Trim.Equals(“Order123”)
Select Address = c.ColumnName & (dt.Rows.IndexOf(r) + 1).ToString
).FirstOrDefault
If this helped you fix the problem, please mark as solution so it can help others too
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
