I am using Selenium WebDriver with Java.
I have an Excel spreadsheet with two columns, one for username and another for password. I need to read those values and use them to create new users.
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It only takes a minute to sign up.Sign up to join this community
Well, it depends on the type of excel file. If it is a standard excel file, there is great instructions on reading them here.
If it is a CSV based excel file than treat it as reading a standard text file and do a comma (Or whatever delimiter it uses) as a split. Instructions can be found here.
After you have the data, I would personally store them to a hashmap or some other system to track the value pair and then loop through the hashmap (Key being username, value being password) using a .keySet() and then check for those values.
I wrote an example project that uses Java and runs your tests on SauceLabs. In this example I drive the tests from a .CSV spreadsheet. You could easily edit this project to do your required testing and then you can hook the test up to a Jenkins job to run them on a scheduled basis.