Copy and paste worksheet range issues
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-05-20 07:22 PM
Hello everyone!
I'm experiencing the following error while using the action on MS Excel VBO - Copy and paste worksheet range: failed to copy worksheet:error message: 'PasteSpecial method of Range class failed.
I'm experiencing the following error while using the action on MS Excel VBO - Copy and paste worksheet range: failed to copy worksheet:error message: 'PasteSpecial method of Range class failed.
I'm actually using the action MS Excel VBO - Get number of rows to calculate the number of rows to paste and after I'm using the output of this action in "copy and paste..."
I am trying to copy around 1k rows/2k rows.
Can you suggest any valid alternative to copy and paste worksheet range action?
Thanks
Thanks
------------------------------
Matteo Pavone
------------------------------
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-05-20 11:31 AM
Hi Matteo - try to make it work with a small range first, eg 10x20. If that works, then maybe it's something related to the volume of data.
Alternatively, in the Queue Reports object on the #Create Performance Report page, there is a code stage called Write Performance Data that might be helpful. You'll need to adapt the code but the technique (to populate an object array that you then write into a range) works well with large amounts of data.
http://portal.blueprism.com/system/files/vbos/Queue%20Reports.bprelease
------------------------------
John Carter
Professional Services
Blue Prism
------------------------------
Alternatively, in the Queue Reports object on the #Create Performance Report page, there is a code stage called Write Performance Data that might be helpful. You'll need to adapt the code but the technique (to populate an object array that you then write into a range) works well with large amounts of data.
http://portal.blueprism.com/system/files/vbos/Queue%20Reports.bprelease
------------------------------
John Carter
Professional Services
Blue Prism
------------------------------
