Intro
Paylook, a big payroll consulting company, needs help automating business applications.
What you will learn
- Primarily:
- Open applications
- Automate applications
- Dynamic selectors
- Close applications
- Secondarily:
- String manipulation
Client Name
Paylook
Process Name
Applications
Description
A high-profile payroll consulting company needs your help automating its favorite application.
- Open the Windows Calculator Application (we use this because everyone have it installed and because the solution are the same in simple and advanced applications)
- Make a dynamic solution that
- Take two numbers from the user (Display input dialog x 2)
- Make addition of the two numbers using the Windows Calculator
- Scrape the result and write it in a log message
- Close the application
- Advanced
- Read the Excel data
- Do the calculation for each row and write the result back into the Excel sheet
Hints
- Run application
- Find the path by looking in C:\Windows\System32\
- Display Input
- Store it in a variable
- Display Input
- Store it in another variable
- Click UI element in window to click on C and clear whatever might be on the calculator
- Click UI element in window
- Make a dynamic selector with the first variable
- Click UI element in window to click the + sign
- Click UI element in window
- Make a dynamic selector with the second variable
- Click UI element to click the equal sign
- Extract data from window to scrape the result and store it into a variable
- Get subtext to remove the ‘Display is ‘
- Display message to display the result
- Terminate process to close an app