When I am trying to copy a full sheet to another sheet by using get collection and write collection

[RPAJob_Opportun]

When I am trying to copy a full sheet to another sheet by using get collection and write collection functionality, it takes a long long time since my excel sheet has a lot of data.

Is there any other way to efficiently copy the sheet to another sheet.

------------------------------
RPA Job Opportunity
------------------------------

[RobinToll · Accepted solution]

I'm assuming based on the phrasing ("Sheet to sheet") that you mean Excel, and based on that two alternate possibilities immediately come to mind:

1. Use keyboard shortcuts (e.g. "Select All", "Copy", "Paste") instead of using the VBO functions. The VBO, for "get collection" and "write collection", is introducing overhead - construct the collection, fill it, etc. Using keyboard shortcuts relies only on the client and the OS, reducing overhead and possibly speeding it up.
2. OleDB can - depending on circumstance - offer significant efficiencies for raw data reads/writes.

That being said, I'd love to hear other suggestions from the community.

If you don't mean Excel, could you please clarify?
Thanks!

------------------------------
Robin Toll
Senior Technical Consultant
Blue Prism
Professional Services Americas
Infrastructure & Architecture Specialist
------------------------------

[RPAJob_Opportun]

Thank you Robin for your help.
Yes this is excel.

We are working on a project automation where our Federal client just bought the Blue Prism license  and they have a large volume of data to be dealt.
and the data will keep growing.

Could you please help guide me how to use the following approach via Blue Prism : Use keyboard shortcuts (e.g. "Select All", "Copy", "Paste") .

Appreciate your help and thank you very much!!

------------------------------
RPA Job Opportunity
------------------------------