Extracting Datatable and Setting up filter at the same time


While using activity ‘Read range’ to extract DataTable I need to preserve the format of the data.
Due to amount of the data it takes too much time to build the DT so I need to decrease number of the data using the filter.

Is it possible to set up filter on the DataTable at the same time it is being created?

what is the column you wanted to filter?

One option would be using LINQ query which would be faster (without using preserve format)

can you filter the table in excel through vba/custom activty then when using read range you can tick the “useFilter” property so that it only extracts the filtered data