Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Isaiah Rosales (IsaiahR9)
Sun Life Financial Inc

Sun Life Financial Inc
PH
IsaiahR9 Member since 2017 19 posts
Sun Life Financial Inc
Posted: Jan 15, 2018
Last activity: Nov 6, 2018
Posted: 15 Jan 2018 21:10 EST
Last activity: 6 Nov 2018 20:02 EST
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.

To see attachments, please log in.
Robotic Process Automation

Posted: 6 years ago
Posted: 16 Jan 2018 3:55 EST
Mohammad Asif Hasan (Mohammad_Asif_Hasan)
EPAM Systems, Inc.
Mohammad Asif Hasan
EPAM Systems, Inc.
ES

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://collaborate.pega.com/question/pega-rpa-can-someone-help-us-how-copy-excel-range-and-paste-it-other-excel-file (Review it for details)

Hope this helps, kindly notify by marking this post as answered.

Regards,

Asif

To see attachments, please log in.

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.

Close Deprecation Notice