I have a excel sheet , from that I want to Create new Data table based on some conditions. it happens with build table activity but i don’t how use it
The best approach is to read in the file using the Excel Application Scope and Read Range activities. This will automatically create the datatable for you at which point you can perform various operations to filter the data.
Try the tutorial below for starters…
i don’t want to use filter activity
You have the options of Datatable.Select (Linq queries)
Looping through the datatable and deleting rows you don’t want with a For Each Row loop.
You don’t have to use Filter Activities.