The Python Papers

The Python Papers

Share this post

The Python Papers
The Python Papers
[0007] - Reading Spreadsheets with OpenPyXL
Copy link
Facebook
Email
Notes
More

[0007] - Reading Spreadsheets with OpenPyXL

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

Share this post

The Python Papers
The Python Papers
[0007] - Reading Spreadsheets with OpenPyXL
Copy link
Facebook
Email
Notes
More
2
Share

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…

Keep reading with a 7-day free trial

Subscribe to The Python Papers to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Mike Driscoll
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share

Copy link
Facebook
Email
Notes
More