studiox
2022.4
false
- 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: Filtering Data in Excel
StudioX User Guide
Last updated Aug 7, 2024
Tutorial: Filtering Data in Excel
In this tutorial, we will create an automation for the following process:
- Copy the data in a spreadsheet with supplier information to a new sheet.
- Filter the data to show only the rows with suppliers from the Services and IT industries that were added in the last 10 years.
- Copy the filtered data to a CSV file.
- Send the CSV file by email.
We will create a project with the following activities:
- A Use Excel File activity to indicate the Excel file with supplier information.
- A Copy Range activity to copy the data to another sheet.
- Two Filter activities to filter the data according to the desired criteria: one filter for the Industry column, the other for the Supplier Since column.
- A Write CSV activity to copy the filtered data to a CSV file.
- A Use Desktop Outlook App activity to indicate the Outlook account from which to send the email.
- A Send Mail activity to send the email.