Discussion

2
Replies
1694
Views
jeffbadger Member since 2016 9 posts
PEGA
Posted: February 5, 2019
Last activity: September 16, 2019

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
Robotic Process Automation Developer Knowledge Share
Share this page LinkedIn