Python Part 17a- Excel using openpyxl

By Andy Brown

After a discussion of the various ways of working with Excel from within Python, learn how to create Excel workbooks and worksheets, reference cells and loop over worksheets and cells using the openpyxl module.

Chapters
00:00 Topic list
01:10 Choices for working with Excel
03:26 Getting started/referencing cells
08:04 Workbooks
12:51 Worksheets
19:31 Looping over worksheets
23:09 Looping over cells / offsetting

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

[genechicago]

LOL...your last comment makes a lot of sense. 70% of my time is spent working with Excel, so I should master Excel VBA first. Thanks to some of your VBA videos I've been able to automate some routine tasks. Thank you!

[JHatLpool]

All of the demos and descriptions in this tutorial are really good. A big +1 'thumbs up' from me.

[needtorename]

As I an expert in VBA, this lecture was a piece of cake.

[yp]

Once again wiseowl helped me a great deal with a coding problem I've been having. Thank you so much!

[MagnusAnand]

About your last comment, about using VBA.
The nice thing about Python is that you have a big ecosystem of libraries and you can work in a nice editor like VS Code or Pycharm, while the VBA editor sucks.

If you’re using excel as a central unit, but then you need to connect to external APIs, create nice charts, etc, Python is much more convenient.

[wayneedmondson]

Thanks Andy! Interesting and useful. Thumbs up!!

[harisow]

Hi Andy, thank you very much ❤❤❤ for teaching PYTHON to us

[hadibq]

Thanks Andy for the excellent tutorials on WiseOwl !! Would it be possible kindly to add the related Playlist link in the videos' descriptions as Youtube doesn't offer this feature as of yet :) . kind of improvement indeed.