Find a specific value location


I used the “Look Up Range” and repeated the sentence
It’s only extracted as “A1”

I’d like to extract all the locations with A values on them.

I ask for your help me.


Can you try the following steps?

First, Read the table using ReadRange activity without addHeader option.(Let’s say dt)
Next, set keyword like keyword="A"
Then the following expression returns array of cell address string.

arrCellAddress = dt.AsEnumerable.SelectMany(Function(r,i) r.ItemArray.Select(Function(o,c) if(o.ToString=keyword,UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(c+1)+(i+1).ToString,"")).Where(Function(s) not String.IsNullOrEmpty(s))).ToArray


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.