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

 FNU Syed Ikramul Hassan (SIkram26)
Accenture

Accenture
US
SIkram26 Member since 2016 1 post
Accenture
Posted: Jul 5, 2017
Last activity: Jul 6, 2017
Posted: 5 Jul 2017 17:30 EDT
Last activity: 6 Jul 2017 17:52 EDT
Closed

RPA with Excel Spreadsheet

Hi ,

I need to perform automation between two excel files
1. ID's (First Excel file contains ID, Date etc...)
2. Employees ID with other details (Second Excel file contains Employee ID too and other details )
With ID i have to look for its details in 2nd excel file.. manually we can copy ID n look for details into another excel file but I have to Automate this process to ID column in 1st Excel file a link, like when user click on a ID from 1st excel file the information related to that ID has to be display on a dialog or window from 2nd Excel file.

***Moderator Edit: Vidyaranjan | Updated Categories***

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 6 Jul 2017 17:52 EDT
Andrew Grondin (grona) GCS Solutions Engineer I
Pegasystems Inc.
US

You need to use the excel connector. Keep in mind that you must install the Office connector of the appropriate version number during Pega installation.

http://help.openspan.com/80/Components/Using_the_Microsoft_Excel_Component.htm

http://help.openspan.com/80/Components/Microsoft_Excel.htm

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