Reading Workbooks

openpyxl is the standard library for reading and writing modern Excel files (the .xlsx format). It lets Python automate spreadsheet tasks that people otherwise do by hand.

This lesson focuses on opening files and reading their contents.

Excel files have a clear hierarchy that openpyxl mirrors:

• Workbook the whole file
• Worksheet one tab inside it
• Cell a single A1-style box with a value

You navigate from workbook to worksheet to cell.