Blue Prism Copy Columns from one Excel File to another

amantiwari

New Member
Hello, I am trying to copy column(s) from one excel file to another using Copy and Paste worksheet range action of MS Excel VBO of blue prism. But i am not having a proper understanding of whats the format or syntax of specifying the cells range. I am getting the following error as seen in the attachment. I have also attached the Action stage configuration also. Please help me with the same.

Thanks.
 

Attachments

  • ErrorCopy.PNG
    5.6 KB · Views: 60
  • CopyAction.PNG
    31.4 KB · Views: 62

renaldooo

New Member
Hello, This action pretty useless. I used it for copy a sheet to another excel, but sometime doesn't worked.
Just Copy it into Collection and keep that column what you need and after that use the Write To Collection action.
 

amantiwari

New Member
Hello , As of now i am using Copy and Paste Worksheet range action of MS Excel VBO and i am getting following error as specified in the screenshot:
How to resolve this?
 

Attachments

  • ErrorCopy.PNG
    5.6 KB · Views: 43

Jiri.Hurda

New Member
Hello, I am trying to copy column(s) from one excel file to another using Copy and Paste worksheet range action of MS Excel VBO of blue prism. But i am not having a proper understanding of whats the format or syntax of specifying the cells range. I am getting the following error as seen in the attachment. I have also attached the Action stage configuration also. Please help me with the same.

Thanks.

Hi, it depends what you copy. Writting from collection is ussually very slow to me because I copy a lot of data.

I have no clear answer for you. You can try to copy the whole column Range1 = A:A.
I think the workbooks must be visible as well >> use Show before copy

Make sure you get right number of row. RC1 is strange naming, consider that it means the full cell reference in excel. However you have it formatted as number so I guess you really have a number there. Make sure that it is not a zero.

There should be also a way how to use basic functionalities in BP. Activate Sheet, Select range, Copy, Activate Destination sheet, Select cell, Paste.
 
Top