How can i filter 1 lakh rows in excel with specific filter ? how i do this can anyone tell me about this
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!!
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: