Topic Thread

Expand all | Collapse all

Copy and Paste Worksheet Range Issue

  • 1.  Copy and Paste Worksheet Range Issue

    Posted 06-08-2020 14:56
    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

  • 2.  RE: Copy and Paste Worksheet Range Issue

    Posted 06-11-2020 06:43

    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

  • 3.  RE: Copy and Paste Worksheet Range Issue

    Posted 06-11-2020 07:42

    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



    Automation Delivery Team | China Service Center


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


    Tel: (+86 20) 2882 5022




    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.