Python Excel openpyxl - Reading Excel files with openpyxl

The Python Excel series is a collection of tutorials focused on work with Python and Excel. In this tutorial we introduce one of many methods of working with Excel and Python openpyxl. We use openpyxl to load the Workbook, look at how to work with worksheets. retrieve cell values
retrieve multiple values and finally converting data into Python data structures.

00:00 Introduction

Code Repository:

🏅 Python Beginners Course:

🐱‍🏍Would you like to SUPPORT US FURTHER so that we can make even more great content - Please consider joining our members community.

👍SUBSCRIBE to get more free tutorials, courses and code snippets!

[AcademyOmen]

Woah, Love the new Thumbnails 😊😸. Always Great as Usual

[mohamed_bouallegue]

Hello zander, thanks for the openpyxl tuto i wanted to ask did you work with word documents the py-docx library ?

[hamzawaleed]

Hi, how would you read in/ get the formatting of a cell? specifically, how do you read in the indentation of a cell using this library?

[drdarbandi]

Nice job There Mate Just Be a Little More Faster hope you the Best From Iran

[sarthakdhaneshwar]

I have a folder with more than 100 excel workbooks in it. If i want to read all of that, how do i do that?