Filter excel data

[yogitagaikwad2206]

How can i filter 1 lakh rows in excel with specific filter ? how i do this can anyone tell me about this

[mkankatala (Mahesh Kankatala)]

Hi @yogitagaikwad2206

You can write the vb code for this, use the vb code in Invoke Vba activity Or simply you can use LINQ Expression by converting the excel to datatable.

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @yogitagaikwad2206

Use Linq queries or Filter datatable

[ppr (Peter Preuss)]

when data is present within a datatable we can do:

• filter datatable Activity
• Select Method from the DataTable
• LINQ Where Operator

Also have a look here:

Four Ways to Filter Data Tables in UiPath Studio | UiPath

DataTable.Select Method (System.Data)

DataColumn.Expression Property (System.Data)

[HowTo] LINQ - First Start # Where Operator

This HowTo introduces how to use the Where operator. Introduction The Where operator is used for filtering. For the filtering, a condition is provided. All items matching this condition will pass the filter and will be part of the returned result. The condition has mandatory to return a boolean outcome. In other words: The result of the condition has to be True or False. Example IPO Samples Comment Values: 20,3,17,22,10,25,5 A collection of Numbers Filter Condition: x > 15 x is th…