openpyxl — read an .xlsx file — Python for Office Workers

← Courses›Python for Office WorkersModule 1 · Excel & CSV›openpyxl — read an .xlsx filepredict3 / 50

Task

Given this sheet (rows shown below as Python dicts for clarity):

  A1='Item', B1='Qty'
  A2='Pen',  B2=3
  A3='Cup',  B3=7

What does this print?

  for row in sheet.iter_rows(min_row=2, values_only=True):
      print(row[0], row[1])

Type the exact output (two lines).

Keep going

📋predict

openpyxl — write a new spreadsheet

📋quizFREE

Why automate office work with Python?

📋write

Read a CSV with DictReader

🔮 Predict the output

Read the code carefully

What will the program print? Write here:

Keep going

💬 Discussion