Automate Excel With Python - Python Excel Tutorial (OpenPyXL)

Welcome to another video! In this video, I will cover how we can use python to automate Excel. I'll be going over everything from creating workbooks to accessing individual cells and stylizing cells. There is a ton of things that you can do with Excel but I'll just be covering the core/base things in OpenPyXl.

📄 Resources 📄

⭐️ Timestamps ⭐️
00:00 | Introduction
02:14 | Installing openpyxl
03:19 | Testing Installation
04:25 | Loading an Existing Workbook
06:46 | Accessing Worksheets
07:37 | Accessing Cell Values
08:58 | Saving Workbooks
09:52 | Creating, Listing and Changing Sheets
11:50 | Creating a New Workbook
12:39 | Adding/Appending Rows
14:26 | Accessing Multiple Cells
20:46 | Merging Cells
22:27 | Inserting and Deleting Rows
23:35 | Inserting and Deleting Columns
24:48 | Copying and Moving Cells
26:06 | Practical Example, Formulas & Cell Styling

◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
💰 Courses & Merch 💰

🔗 Social Medias 🔗

🎬 My YouTube Gear 🎬

💸 Donations 💸
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️

⭐️ Tags ⭐️
- Tech With Tim
- Python
- Excel
- Python Tutorial
- Python and Excel
- Automating Excel

⭐️ Hashtags ⭐️
#TechWithTim #PythonExcelTutorial

[derekwest]

New to python and starting my own project working with excel files. Tried to go through the documentation for openpyxl and was wasting alot of time learning unnecessary information based on what I was trying to accomplish. You've done a wonderful job with this and I was able to easily follow along and experiment along the way. Put together a py file for my notes on this module. Tim is Great!

[chaitanyakolluri]

Hands done one of the best Python training videos out there I’ve. Method of instruction, clarity and examples are brilliant. Thank you so much.

[lilrex]

This is quality stuff. This guy gets how to make a good tutorial video. No wasted time, points are explained enough to understand then moves on.

[TheNameIsForty]

Actually did something similar a month ago, where I converted the excel file in to base64 in the end and sent it through an API to then generate it back into xlsc format through typescript.
PyXl is amazing btw, anyone who watches this should try it. Very easy to use.

[NextManu]

recently got into learning python.
my mind is blown with the versatility of python. I now wish i had done software engineering back in school..

[VladArnoldner]

I am working as a Senior Financial Officer dealing with financial reporting. This video gives me a new powerful tool to quickly manipulate and process a large volume of data. I think I will surprize my boss with my new skills! Thank you, Tim!!!

[gl]

Boomers at my work will now treat me as a god

[boldtecmedia]

exactly what i needed, im a civil engineer and learning python. i was coding a building cost estimator desktop app in tkinter and needed python after calculating all materials for me, it should also create an excel workbook and type those results for me. so that i simply print out for the client in the shortest time possible. awesome video. thank you sir.

im a complete beginner though, any one with a better way of doing it is welcome

[preisback]

I've been learning Python by following a book and got confused and stuck for so long until I found this video. Thanks

[dmitryg]

man, I really appreciate your work and time spent on explanation. I would never sort it out without your help

[addledanorak]

Was waiting for such a vid for soooo Thx Tim :)

[relhage]

Clear, rich, concise and well delivered. Thanks!

[pythonenthusiast]

to those who are thinking @6:52 that you can directly open the workbook or directly save the workbook using that load_workbook command.. no ppl.. you need to first make or upload a workbook at the location of your text editor or some random location then take that location from there .

[simoneriksson]

Awesome video Tim! Ive struggled a bit with python and definently had some 'aha!' oments watching this! Keep up the good work!

[jewelsoncagakit]

Wow ! All the basic fundamentals are packed in one demo ! Thanks Tim !

[omuk]

Who the heck is this guy!! Just amazing trainings and super easy to follow along. Keep them coming Tim, much appreciated.

[deanlawson]

Excellent run-through of this. Very cool to be able to interact with Excel spreadsheets in Python!
Thanks for this - Nicely done!

[manndipp]

by far, the best video for starting excel with python

[CarlFritz]

AMAZING, Tim. The best demonstrated matter I have ever seen.

[ianbraganza]

Thanks for a great video. It helped me automate several redundant tasks and opened my mind to the power of openpyxl