- Release Notes
- Getting Started
- Tutorials
- Automation Projects
- Creating Automations
- Automation Basics
- Object Repository
- Automation Best Practices
- Tutorial: Creating a Pivot Table
- Tutorial: Iterating Through Rows in a Table
- Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
- Tutorial: Extracting Data From Automated Emails and Moving It to a Desktop Application
- Tutorial: Filtering Data in Excel
- Tutorial: Formatting Cells
- Tutorial: Adding Information About the Files in a Folder to an Excel File
- Tutorial: Adding Your Own Formulas to the Project Notebook
- PowerPoint Automation
- Data Automation
- Common Activities
- Google Workspace Automation
- OneDrive & SharePoint Automation
- Troubleshooting
Tutorial: Iterating Through Rows in a Table
In this tutorial, we will create an automation to repeat the following workflow for every row in an Excel table that does not already have a value for the Transaction #:
- Copy the value from the cell in the Cash In column.
- Paste the value to a field in a desktop application.
- Copy the transaction number from the desktop application.
- Paste the value to the cell in the Transaction # column.
- Click a button in the desktop application to submit the data.
We will create a project and start by adding a Use Excel File activity to indicate the Excel file to use. Inside this activity, we will add a For Each Excel Row activity to indicate that the activities should be repeated for each row as we iterate through them. Because we only want the automation to execute for the rows in our Excel file that do not contain a Transaction # value, we will add an If activity inside the For Each Excel Row activity to indicate that the activities to automate should only be executed for the rows that meet the condition that the Transaction # cell is empty.