Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Read and Write Excel Files in Python

Introduction
4. Exercise 3

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:
    ...