Question
1
Replies
1425
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.
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