3
), # For demonstration purposes only. Fills in info and then waits 3 seconds.
form.select(selector='.loginBtn')
])
with form.frame('topFrame'):
form.fill([form.select(id='AUDButton')])
# Clicking the .loginBtn will cause the form to submit and we'll be navigated to a new page.
# Now we want to submit the form a bunch of times. Let's use our spreadsheet.
for row in spreadsheet.rows:
# We can update the spreadsheet with data from the form.
# Here, we are updating the AUD column of each row to be the text of the #aud element.
row.set('AUD', form.select(id='aud').text)
# Because we are using fill_from_row, the elements will automatically get their values from the spreadsheet
# for the current row and at the column specified by the `col` field.
form.fill_from_row(row, [
form.select(id='companyId', col='Company ID'),
form.select(id='userId', col='User ID'),
form.select(id='password', col='Password'),
form.select(id='securityMsgAck1'),
SleepElement(3),
form.select(selector='.loginBtn')
])
# After updating the spreadsheet, make sure to save it back to the file.
spreadsheet.save()
print('Done!')
