Tuesday, September 1, 2020

Editing Excel Spreadsheets in Python With openpyxl

Excel spreadsheets are one of those things you might have to deal with at some point. Either it’s because your boss loves them or because marketing needs them, you might have to learn how to work with spreadsheets in Python, and that’s when knowing openpyxl comes in handy!

In this course, you’ll learn how to use openpyxl to:

  • Read Excel spreadsheets and iterate through the data
  • Manipulate speadsheet data using Python data structures
  • Create simple or more complex spreadsheets
  • Format workbooks using styles, filters, and conditional formatting
  • Enhance spreadsheets by adding images and charts

[ Improve Your Python With 🐍 Python Tricks πŸ’Œ – Get a short & sweet Python Trick delivered to your inbox every couple of days. >> Click here to learn more and see examples ]



from Real Python
read more

No comments:

Post a Comment

TestDriven.io: Working with Static and Media Files in Django

This article looks at how to work with static and media files in a Django project, locally and in production. from Planet Python via read...