Pega RPA. Can someone help us on how to copy an excel range and paste it in other excel file.
As shown in the image below,
using excel range, copy the data from source to destination.
Thank you very much in advance for your help.
Regards,
Jessa
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
US
The Excel connector has two methods that would accomplish this; ExportData and ImportData. You can call ExportData on the cells you wish to export which will return a DataTable. You can then pass this into the method ImportData and set the cells that you wish to move the data into.
Updated: 26 Jun 2017 2:17 EDT
Nestle Business Services Aoa Inc
PH
Hi @sasnt,
Thanks for the answer, it hepls a lot. I've attached the image of your suggestion and it really worked.
But what if there is no exact row count to be copied from the source?
Thanks in advance.
Pegasystems Inc.
US
The best answer is that there would be some logic and calculation involved. The easiest way using the components available would be to iterate through each row using GetCellValue until you get to the end of your range. You'd record this value and use it as the second parameter on ExportData.
You can also do this in C# and that would likely be faster if you had a lot of rows (more than say 25). You would basically export the data from your start until some large number that would always exceed the amount of rows you would have. Then, you'd pass the DataTable into a C# script and remove any of the blank rows from it. Then you could pass this DataTable back into the destination worksheet.