Extracting Datatable and Setting up filter at the same time

Help Activities
, ,
1

Hi,

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?

2

what is the column you wanted to filter?

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

3

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

image
image1101×392 19 KB