Skip to main content

Discussion

 Jeff Badger (jeffbadger)
PEGA
Principal Product Manager, Robotics
Pegasystems Inc.
US
jeffbadger Member since 2016 59 posts
PEGA
Posted: Feb 5, 2019
Last activity: Sep 16, 2019
Posted: 5 Feb 2019 7:44 EST
Last activity: 16 Sep 2019 5:53 EDT

Excel sample automations

The Using Microsoft Office Connectors document has been updated with a series of examples for Excel.

  • Exporting data into a datatable
  • Exporting data to a lookup table
  • Extracting a proxy
  • Importing data into a worksheet
  • Opening a Read-Only or password protected workbook
  • Reading cells dynamically
  • Running a macro
  • Setting a column to AutoFilter
  • Setting the font for a range
  • Showing or hiding a worksheet column
To see attachments, please log in.
Robotic Process Automation
Developer Knowledge Share

  • Reply
Posted: 5 years ago
Updated: 5 years ago
Posted: 16 Sep 2019 5:52 EDT
Updated: 16 Sep 2019 5:53 EDT
Lochana Durgada Vijayakumar (Lochan_DV)
PEGA
Senior Manager, Knowledge Management
Pegasystems Inc.
IN

Hello!

I edited the above post for the working URL: https://community.pega.com/knowledgebase/documents/using-microsoft-office-connectors

All the examples can be found under the Topic: MicrosoftExcel Connector examples

To see attachments, please log in.

Related content:

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