Filtering Excel and writing the output to a different Excel file

Help
4

I would solve this by using two datatables in the following method:
1 read range of the first Excel file (DT_Unfiltered)
2 assign DT_Filtered = DT_Unfiltered.Select(“[Column1] = ‘Criteria1’”).CopyToDatatable
3 write range to the second Excel (DT_Filtered)

Find attached an example workflow
Filter_Excel.xaml (8.5 KB)

5 Likes