Question
1
Replies
1473
Views
Posted: January 15, 2018
Last activity: November 6, 2018
Closed
Copy all data of excel workbook cell values to another excel workbook
Hi i need to make an automation to copy everything from an excel workbook to another excel workbook. Is this possible? Thanks.
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Hi Isaiah,
Thanks for posting on PSC.
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.
Reference:- https://pdn.pega.com/community/product-support/question/pega-rpa-can-someone-help-us-how-copy-excel-range-and-paste-it (Review it for details)
Hope this helps, kindly notify by marking this post as answered.
Regards,
Asif