Okay, you've seen that printing each row resulted in a tuple of cells. How can we access a given cell, and more importantly, the value it contains? We have to add an inner loop, so we can iterate directly over each row"s cells:
for row in worksheet["A1":"D6"]:
for cell in row:
print(cell.value)
In the outer loop, we iterate through all possible rows. In the inner loop, we access each element in a given row, or each particular cell.
Okay, let's iterate over a spreadsheet containing a small table that indicates whether a given day was a workout day or not, as indicated by the sample below:
Your job is to find the total number of workout days. Each workout day is indicated with a "+" inside a cell. Create the workout_days_number variable and save the final result to it. Print the result. The whole table spans from A1 to E20.
Iterate over every row and every cell. If the cell value equals +, add 1 to the workout_days_number variable.
