How to extract "specific data rows" from excel


How can I extract all of the data roles that has “LT” rank into a new excel?



Do I have to use the Excel Application Scope, then read the excel fast, and do a filter table that contains “LT” in rank column?


or use filter table activity and configure your column name and value

1 Like

check this → Four Ways to Filter Data Tables in UiPath Studio | UiPath

1 Like

Hi @Hey_hi ,

Here we go… Specific data rows…Xaml attached

Extract Specific Data (13.3 KB)

1 Like

DT.Asenumerable.Where(Function(r) r(“Rank”).Tostring.Trim.Tolower.Equals(“lt”)).Copytodatatable

Output : Datatable With Rows Having “LT” only.

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