Question

1
Replies
1491
Views
 Isaiah Rosales (IsaiahR9)
Sun Life Financial Inc

Sun Life Financial Inc
PH
IsaiahR9 Member since 2017 19 posts
Sun Life Financial Inc
Posted: January 15, 2018
Last activity: November 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.

Robotic Process Automation
Moderation Team has archived post, 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.
Posted: 3 years ago
Posted: 16 Jan 2018 3:55 EST
Mohammad Asif Hasan (Asif Hasan)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

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