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.
Posted: 2 years ago
We'd prefer it if you saw us at our best.
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.
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-so… (Review it for details)
Hope this helps, kindly notify by marking this post as answered.
Regards,
Asif