Skip to main content

How to configure an Excel Range to automate

Product How-To | June 8, 2019 | 02:17

Some processes utilize hourly, daily, or weekly spreadsheets that always contain the same basic data but the number of rows may vary. The ExcelFile connector now offers the ability to define a range and access the data within it. This video shows how to configure the ExcelFileRange and implement a basic search that loops within the range.

How to configure an Excel Range to automate

Related Videos

Pega Robotics v22 Update: What's New in Pega Robotic Automation
Video duration: 18:49

In this video, Katie Alberti, Sr. Product Marketing Manager, Intelligent Automation, chats with Becky Blackwell, Director,…

Episode 43: The art of Auto-balancing
Video duration: 12:15

Emily Calo, Product Marketing Manager, and Becky Blackwell, Director, Product Management, discuss how developers can benefit…

How to interrogate a Single Web Page application
Video duration: 01:54

A single-page application (SPA) is a web application that retrieves all the necessary code — HTML, JavaScript, and CSS —…

How to implement dialog boxes in an automation
Video duration: 02:29

When developing attended RPA solutions, processes and tasks require the user to interact with files. Pega Robot Studio…

Product How-to | How to implement parallel processing in a robotic automation
Video duration: 01:52

Often it is necessary to perform parallel processes in one automation by creating asynchronous threads for each process…

How to automate partial screens in text adapters
Video duration: 02:06

Mainframe systems provide lists and lists of database rows that a user must then cycle through to find the needed item. This…

How to add and invoke Javascript in an automation
Video duration: 02:16

Javascript is a universal web programming language, and often it is necessary to include custom Javascript code or invoke a…

Product How-To | How to automate receiving a new email in Outlook
Video duration: 01:47

Quite often companies use generic email accounts where customers may send their questions or issues for resolution. Being…

Product How-To | How to perform different tasks using the Switch component
Video duration: 01:13

Often the next step in a process may change or switch depending on what value or input is selected or used. This video shows…

How to retrieve Outlook emails using the Outlook connector
Video duration: 02:04

Company style email addresses are not always monitored to read emails for processing work. This video shows how to use the…

View All Videos

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us