Filter excel data

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

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!!

Hi @yogitagaikwad2206

Use Linq queries or Filter datatable

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: