Discussion

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

Comments

Keep up to date on this post and subscribe to comments

September 16, 2019 - 3:57am

Above Links are not working .

 

Mod
September 16, 2019 - 5:52am
Response to AnitK860

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

Lochana | Community Moderator | Pegasystems Inc.