Adding the Excel File Connector
To work with an Excel worksheet in an automation, follow these steps:
In Pega Robot Studio, open Object Explorer.
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 Properties, Events, and Methods
