From the course: Scripting for Testers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Simple test report webpage

Solution: Simple test report webpage - Python Tutorial

From the course: Scripting for Testers

Start my 1-month free trial

Solution: Simple test report webpage

“

- [Instructor] So, this challenge was pretty tough, so hopefully you were able to figure it out. If you did, congratulations. If you ended up getting stuck, don't worry about it too much. This was a complicated example, pulling together almost everything that we've learned so far. Getting stuck is part of the learning process. If you stick with it, you'll only find that it gets easier and easier to figure things out. So, let's just take a minute to walk through my solution to see how I solve this. So, the first thing that we needed to do was to read in the data from the spreadsheet. We can do that, of course, using the get all values command. So, here we have sheet.get_all_values. And, that reads the data into our spreadsheet data. Now, so since we weren't interested in the first two columns of the spreadsheet, we can just delete them from the data. So, we'll loop over our spreadsheet data, and we'll delete row zero and row one, to delete the first two columns, and then we'll add that…

Contents