...
This example will prompt the user for an Excel file. Then loop through the rows and enter them into a website. This website has controls that move every time the page is refreshed, but not to worry, Aria Aura can handle this easily!
| Code Block |
|---|
Prompt User "Please upload your Excel file" $myExcel -excel
$rpasite = "http://www.rpachallenge.com/"
navigate to $rpasite
foreach ($row in $myExcel)
{
//Variables in foreach loops are auto generated
//Use inspector to get variable names,
//they will be the column headers without spaces and special characters
switch to $rpasite
Enter $FirstName as "First Name" -forcedetection
Enter $LastName as "Last Name"
Enter $PhoneNumber as "Phone Number"
Enter $CompanyName as "Company Name"
Enter $RoleInCompany as "Role in Company"
Enter $Email as "Email"
Enter $Address as "Address"
Click "Submit" button -nearest("address")
switch to $myExcel
Set value "Is Completed" as "Yes"
} |
...