Python and Excel Programming With OpenPyXL

Use OpenPyXL To Connect Python And Excel - Unlock The Power Of Python Programming and Excel Spreadsheets

4.25 (297 reviews)

Udemy

platform

English

language

Other

What you will learn

Learn How To Use Python and Excel together with OpenPyXL

How to Install and Use The OpenPyXL Library For Python

How To Connect and Excel Spreadsheet to Your Python Code

Create Spreadsheets Using Python

Why take this course?

In this course you'll learn how to use the OpenPyXL Library for Python to connect your Python programs to Excel and vice versa.

Using OpenPyXL, you can use Python to do all sorts of cool things in Excel; from creating spreadsheets from your code, to updating existing spreadsheets. You'll be able to load data from a spreadsheet into your python program and do anything you want with it, and then save it back to the spreadsheet.

We'll learn how to style spreadsheets using Python, and also how to make basic charts and graphs in a spreadsheet using Python.

You'll learn...

- Install Python

- Install Sublime Text and Git Bash Terminal

- Set up a Virtual Environment

- Install OpenPyXL

- Create a First Python Program

- Load an Excel Spreadsheet Workbook into a Python Program

- Grab a Spreadsheet Cell Programatically

- Grab whole Columns and Rows from a Spreadsheet with Python

- Change the Data in your Spreadsheet using Python

- Save Changed Spreadsheets from your Python Program

- How to Loop Though A Spreadsheet programatically with Python

- Learn How To Create an Excel Spreadsheet from scratch with Python

- Use Excel Formulas in your Python Code

- Change The Font color, size, boldness, italics and more With Python

- Add Borders to Cells in your Spreadsheet with Python

- Create Pie Charts With Python

- Create Bar Charts With Python

- Create Line Charts With Python

- and More!

At the end of this course you'll be able to use Python to do all sorts of fun things with Spreadsheets, all from your python programs!

See you inside!

- John Elder

Screenshots

Python and Excel Programming With OpenPyXL - Screenshot_01

Python and Excel Programming With OpenPyXL - Screenshot_02

Python and Excel Programming With OpenPyXL - Screenshot_03

Python and Excel Programming With OpenPyXL - Screenshot_04

Reviews

César

October 14, 2023

Un gran profesor. Va a lo esencial, paso a paso. Deja espacio para el autoestudio, la prueba por cuenta propia. Me imagino un segundo nivel de este curso, por ejemplo, interacción de OpenPyXL, xlwings y Excel. Mil gracias.

Rodger

July 14, 2023

Not a fan of Sublime Text. Setting up the virtual environment seemed very Windows specific. Even so, an EXCELLENT course! John's a great teacher.

Alina

March 31, 2022

Comparing with other python courses/the amount of money i paid for this course my rating is 1.5 out of 5.

Edward

November 24, 2021

Just a note for iPad users, although i have windows pc’s and a Mac, i love using my iPad whenever i can and there is an app named Carnets and it’s free. So far, all the code works with it in a Jupiter notebook. I installed all the applications on my windows laptop but i decided to try the iPad and it works. WOW amazing Carnets works and its a free app!!!

Richard

July 24, 2021

Course structure and instruction was very good. The one issue is the omission of a few BASIC things like add and delete rows and columns, copy and delete regions of data (slice), and possibly create and delete sheets in the workbook. All instruction was without error and very clear, just wish the above mentioned had been included. For me those are very important.

Hébert

July 18, 2021

Très bon cours, bien expliqué, j’ai vraiment appris et apprécié. J’avais mes sous-titres cela m’a permis de lire ce que je n’entendais pas facilement. Thanks you John

Sheelah

July 12, 2021

Good content. I find it sometimes difficult to understand exactly what element is being referred to, as the instructor uses the word "THING" all the time to refer to any element from variable, to a library, to a line of code, to an excel spreadsheet, to a tab name. Language is very important when teaching, and attention to language detail would make it infinitely easier to follow.

Konrad

May 15, 2021

The entire course is way too short and just reading the documentation would be better. In fact, reading the documentation would be better because the course does not cover important stuff like creating a new sheet or pivoting a table. In addition, the assumption seems to be that there is literally no python knowledge required which seems weird. I think for people with even a bit of python knowledge a lot of explanations are just boring and pointless and for complete beginners they would be overwhelming. The course basically covers the basics but that is literally it. I'd recommend for maybe something like 3 - 5 dollar. Will try to get a refund.

Christos

February 26, 2021

It was very good and the instructor was excellent. It would be better if the examples were a little more difficult.

Edward

January 11, 2021

Elder made it so easy to automate report generation by writing python codes. I still throw away all these Visual Basic books from now on.

Patrice

January 7, 2021

I think this course is great for people with no previous experience in Python or programming, as you take the time to explain how to set up your environment, and explain with many examples what do what... For someone with a bit more experience in coding, maybe another course more straight to the point would have been more adapted. I would have appreciated maybe a bit more examples for Graphs on how to sort data (alphabetically, by value ascending or descending, ...) how to set background color, .... but we can see that as some homework to dig in the documentation. Thank you very much for your energy and your very detailed clear explanation. I can see you enjoy teaching and sharing. *

Hassan

December 15, 2020

I am from a finance background so I didn't really understand the coding rules but it is pretty amazing how much you can do with python.

Sean

November 22, 2020

Fun, chill teaching style that makes the information very accessible. Great skill at making complicated ideas seem easy.

Rohith

November 21, 2020

Nice course and Elder did a really good job , the way he teaches is good but too short and very basic there are videos with less than 2 minute duration could have get into more details

Narayan

November 16, 2020

Quick, short course explaining clearly how Python can work with Excel, from data to formatting to charts. Clear, good explanations.

Charts

Price

Rating

Enrollment distribution

Python and Excel Programming With OpenPyXL - Distribution chart