Filter Excel column from next 3 days upto coming 365 days (Cannot use Collection)

AsitabhaDeb — Mon, 02 Nov 2020 14:57:00 GMT

Hi Experts,

I have excel file with date column. Now my requirement is I would like to filter the date column from next 3 days up to coming 2-3 years.
I cannot use Collection because my excel file consist 51k data and at the end I need to write collection which is taking long time compare to the manually completion of this process.

For e.g : Column Name
CRD
2019
2020
2021

It will take date from 05.11.2020 (filter out previous month) up to 2022 include all the month and filter out 2019.
I have posted lots of message in this section. Thanks all of you who had helped me.
Please help me to solve this issue.

------------------------------
Asitabha Deb
------------------------------

RE: Filter Excel column from next 3 days upto coming 365 days (Cannot use Collection)

ashish.easow — Wed, 04 Nov 2020 07:07:00 GMT

Hi Asitabha,

have you tried OLE DB with the required date fields in where clause and with select in batches for performance.

regards

------------------------------
Ashish Easow
Senior Consultant - Professional Services
Blueprism
Asia/Kolkata
------------------------------

topic Filter Excel column from next 3 days upto coming 365 days (Cannot use Collection) in Product Forum

Filter Excel column from next 3 days upto coming 365 days (Cannot use Collection)

RE: Filter Excel column from next 3 days upto coming 365 days (Cannot use Collection)