Read Excel and Store in data table based on conditions

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