Excel File Connector

The Excel File Connector expands the functionality of the Microsoft Excel Connector in Robotic Process Automation (RPA) scenarios, when there is no interaction between the user and the Microsoft Excel workbook.

The Excel File Connector provides these benefits:

You can create, modify, and read from Excel workbooks using Pega Robotic Automation without having the Excel application installed in the environment. The system uses the Open Office XML format to create Excel workbooks.
The Excel File Connector includes additional methods that enhance your ability to work with an Excel workbook. With the MicrosoftExcel Connector, you can only get or set cell values and export or import data as data tables.
The Excel File Connector lets you define ranges of data to work with, such as a table. You can define the range during design in Studio or by using an automation during Runtime.

Note: Use the MicrosoftExcel Connector in Robotic Desktop Automation (RDA) automations. For example, use the MicrosoftExcel Connector when you need to automate using events from Excel, scenarios where the user needs to interact with the workbook in Excel, and scenarios where you need to run macros in an Excel document.

Related information

Adding the Excel File Connector

Creating a Range Object

Excel File Connector Properties, Events, and Methods

Range Properties and Methods

Excel File Connector Formulas

Privacy | Trademarks | Terms of Use | Feedback

Updated: 01 July 2024

OpenSpan data classification label