The Python Papers

The Python Papers

Using Pandas to work with Excel

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

OpenPyXL is not the only tool you can use to read and write Excel spreadsheets. One popular package used by the scientific Python community that can read and write Excel spreadsheets is Pandas.

If you look in the Pandas documentation, you will discover that it uses the following Python packages for reading and writing Excel though:

  • xlrd - Reading Excel

  • xlw…

User's avatar

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

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