Question
4
Replies
3243
Views
Posted: June 22, 2017
Last activity: November 6, 2018
Closed
Solved
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.
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.