The Python Papers

Share this post

Using Pandas to work with Excel

www.pythonpapers.com

Using Pandas to work with Excel

Mike Driscoll
May 23, 2023
∙ Paid
7
Share this post

Using Pandas to work with Excel

www.pythonpapers.com
Share

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…

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
© 2023 Mike Driscoll
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing