Instruction
Looking good! This one might be trickier!
Exercise
Load the attendance_list.xlsx file. There is only one worksheet, attendance_list. The structure of the worksheet looks like this:
| class_date | class_date | |
|---|---|---|
| student_name | X | |
| student_name | ||
| student_name |
An X indicates that a given student was absent.
Find the total number of times students were absent. Assign the result to the result variable and print it.
Stuck? Here's a hint!
To iterate over all rows and all columns in a sheet you can use the for loops:
for row in ws:
for cell in row:
...
