Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
//This folder is in My Documents\Digital Workforce\Aura Digital Worker\Assets\
//This path is used to locate files and folders or you can also specify a full path below
$excelFile = ""
$folder = "Test Data"
$rpasite = "http://www.rpachallenge.com/"
navigate to $rpasite
foreach ($excelFile in $folder)
{
foreach ($row in $excelFile)
{
//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
//We are finished inputting values, swith to Excel application/ or file to update a value
switch to $excelFile
Set value "Is Completed" as "Yes"
}
//This will addsend the result to be sent back to the user to open once workflow auttomationautomation is complete.
//WeYou could also use copy or move commands to copy files to another location
//The files are stored on Aura Worker if needed
Add Result $excelFile
}
//This command below will send the results stored to the Aura Desktop
//Once complete, look for a button labelledlabeled 'Open Results'
Send Results to Desktop

...

View file
namechallenge.xlsx

Include Page
Snippet - How-to Foot - Aria
Snippet - How-to Foot - Aria
Multiexcerpt fast include block macro
nameRelated Articles
templateData[]
pageHow to Article - Include Page Stuff
addpanelfalse
Filter by label (Content by label)
showLabelsfalse
max10
showSpacefalse
cqllabel in ( "kb-how-to-article-aria" , "excel" , "loop" , "foreach" , "kb-tech-aria" ) and label in ( "kb-command-reference-aria" , "kb-how-to-article-aria" , "kb-tech-aria" )
Include Page
Snippet - How-to Foot - AriaSnippet - How-to Foot - Aria
Include Page
Snippet - Footer - Tech
Snippet - Footer - Tech