How can we read Excel and filter the data based on conditions and store it in data table
hi @Spoorthi_Chintala1
Reading excel can be achieved easily by using read range activity with or without scope, that will give you the data table as output, then you can use the filter data table activity which receives data table and outputs data table.
2 Likes
can u share me the xaml ?
am able to read the excel but not able to filter based on condition and save it in datatable .so could you please share it