The Python Papers

The Python Papers

[0007] - Reading Spreadsheets with OpenPyXL

Mike Driscoll's avatar
Mike Driscoll
Jan 23, 2023
∙ Paid

There are a couple of fundamental actions that you will do with Microsoft Excel documents. One of the most basic is reading data from an Excel file. You will be learning how to get data from your Excel spreadsheets.

Before you dive into automating Excel with Python, you should understand some of the common terminologies:

  • Spreadsheet or Workbook – The file…

User's avatar

Continue reading this post for free, courtesy of Mike Driscoll.

Or purchase a paid subscription.
© 2026 Mike Driscoll · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture