Adding the Excel File Connector

To work with an Excel worksheet in an automation, follow these steps:

  1. In Robotic Automation Studio, open Object Explorer.

  2. Add the ExcelConnector component. By default, this component is located on the Global tab. You can also add the Excel File Connector to the Global Container.

Use the Excel File Connector properties to configure the connector to work with a worksheet in a workbook. If required, use the Excel File Connector properties to supply a password for the workbook. If you change the worksheet and workbook within an automation, use the Save method to save the modifications to the Excel file.

Related information

Excel File Connector Overview

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: 18 June 2020

© 2016 - 2020 Pegasystems Inc.  Cambridge, MA All rights reserved.


OpenSpan data classification label