topic Issue with pasting filtered data from excel in Digital Exchange

Issue with pasting filtered data from excel

poojagupta83 — Wed, 23 Jul 2025 15:13:04 GMT

I need to paste some filtered data from one sheet into another excel sheet. Sometimes, only the filtered data gets pasted. But at times, all the data gets pasted. I am getting inconsistent results. Also is there a limit on pasting filtered data. BOT is able to paste until 2399 rows only. If there is an object to paste filtered data only. Then it will be helpful.

Re: Issue with pasting filtered data from excel

SouravSaha — Thu, 24 Jul 2025 11:29:43 GMT

Hi @poojagupta83,

Which blue prism object and action are you using to paste the filtered data?

Re: Issue with pasting filtered data from excel

poojagupta83 — Thu, 24 Jul 2025 11:46:58 GMT

I am using MS Excel VBO - Extended(Digital Exchange).

Action - Copy & Paste worksheet range

Re: Issue with pasting filtered data from excel

Nandhakumar — Fri, 25 Jul 2025 02:22:30 GMT

Hi @poojagupta83

Can youtell me on how you are trying to get the range for Copy and Paste action?

Thanks,

Nandha

Re: Issue with pasting filtered data from excel

SouravSaha — Fri, 25 Jul 2025 06:59:06 GMT

@poojagupta83, Your requirement is to get the filtered data only in a new sheet, right?