Practicing Excel automation
In this section, you will practice the concepts learned by interacting with some data in an Excel file. The Excel file consists of employee information such as employee ID, first name, last name, hourly rate, and work hours. Our task is to go through the data and add two new columns in the Excel file.
One column should include the full name (combining the first and the last name) and the other column should consist of the total payment (the hourly rate * work hours) for the employee. Once the report is generated, the robot should also filter the data to find employees who earn more than $2,000 and create a separate Excel file for this data.
Go through the following steps to complete this task:
- Open UiPath Studio and create a new project.
- Open Microsoft Excel and create the data as shown in Figure 9.16:
Figure 9.16 – Excel integration sample data
- Save the Excel file in a folder that can be used as...