How to get the filtered excel output in a datatable?

[aksh1yadav (AKSHAY YADAV)]

@hkjobs1988

Table could bot found as my range is not written in table form

Filter Table activity will work on a table exists inside an Excel.

so better to use Datatable.Select() with your condition which will return an array of DataRow.
Then add that DataRow array in a datatable and then write that Datatable in an Excel.

Not able to fliter excel

I have an excel with multiple colum .I am trying to filter column as “Ccy=EUR” [image] I am using the datatable and select to filter [image] But I am getting this error [image]

Activities - Filter Table

Regards…!!
Aksh