Filter Data Table and save in a new Excel file


I want to filter a DataTable and save the Output Data in a new Excel file.
Filtering works fine, but I’m not sure how to save the filtered data into a new file.

Thanks for help.


Welcome to forums

Once you filtered data in output use another Datatable variable name

Once done use write Range activity and specify the path of the excel and give Datatable as DTFilter from the example

Hope this helps you


1 Like

Thanks for your reply.

But when I specify the path of the new Excel file in Write Range I get this Error: The range does not exist.

SI image_2021-02-25_201606
remove this highlighted part and keep it black and run your process if its work please mark as solution I appreciate