topic RE: Copy and Paste Worksheet Range Issue in Product Forum

Copy and Paste Worksheet Range Issue

EricLi — Mon, 08 Jun 2020 13:56:00 GMT

Hi, may I have your help?

There are more than 1 excel (.xls file) need to be consolidated into one excel (.xlsx file). I use action "Copy and Paste Worksheet Range" of excel vbo. but strangely that sometimes all files can be fully copied and pasted, sometimes only few of them can be copied and pasted, sometimes none of them can be copied and pasted. I try this with the same resource files. what is the problem?

------------------------------
Eric Li
Operation Analysis
AIG
Asia/Hong_Kong
------------------------------

RE: Copy and Paste Worksheet Range Issue

james.man — Thu, 11 Jun 2020 05:43:00 GMT

Hello,

If you try it on the same file, does it consistently fail or succeed? Or is it the case where it will fail on a file, and also succeed on the file seemingly randomly? Alternatively, is it possible to perform all of the excel combining/manipulations as collections from within Blue Prism and then write that out as an Excel file? That way you wouldn't need to use the copy/paste funtions.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

RE: Copy and Paste Worksheet Range Issue

EricLi — Thu, 11 Jun 2020 06:42:00 GMT

Thank you James & Yeswa

Collection way is a stable option. However it is not fit for us because of the efficiency issue. Our source data sometimes contain more than 30k transactions in one workbook, read and write will spend much time. And sometimes will suffer system collapse when read into collection.

Eric Li

AIG

Automation Delivery Team | China Service Center

9F, The Centerpoint (Shuion), 374-2 Beijing Road, Guangzhou, China 510030

Tel: (+86 20) 2882 5022

Eric-F.Li@aig.com | www.aig.com

IMPORTANT NOTICE:

The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by AIG for any loss or damage arising in any way from its use.