How to extract "specific data rows" from excel

[Hey_hi]

Hi,

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

From:

To:

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?

[Veera_Raj (Veeraraj Sethuraman)]

table= table.select(“‘columnname’=‘LT’”).copytodatatable()

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

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

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

[tkiran (Kiran T)]

Hi @Hey_hi ,

Here we go… Specific data rows…Xaml attached

Extract Specific Data rows.zip (13.3 KB)

[Gangadhar_Athili]

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

Output : Datatable With Rows Having “LT” only.