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.
Hi,
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
Regards,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.