Python OpenPyXL Tutorial 🔥: modifying Excel files with Python | Python Excel automation

This Python Openpyxl Tutorial is about How to modify Excel (XLSX) files with Python and openpyxl library, and how to save modified data to a separate Excel XLSX file with Python.

This Python Excel automation and Python Openpyxl Tutorial is a quite detailed explanation how to automate Excel with Python, and fit for absolute beginners.

The Python for Excel and Openpyxl Tutorial includes the following topics:
- how to open Excel files with Python Openpyxl library
- how to get an active spreadsheet
- how to get a value of cells in Excel with Python
- how to save data to an Excel XLSX file with Python
- how to keep Excel formulas in cells when saving to a new file.

Follow me @:

Timecodes:

00:00 - Beginning. The description of the project.
00:40 - Installing Python openpyxl library
01:08 - Reading an excel file with openpyxl library.
01:39 - Getting a working spreadsheet to get data from.
02:46 - The structure of Sheet objects. Iterating through Sheet, and row objects
04:07 - Specifying the range of cells to get.
04:49 - Writing new data to the excel file
06:48 - Saving modified excel file with openpyxl library.

*** Web Scraping course ***
is available via Patreon here:

or its landing:

See Also:
How to read XLSX files and convert them to a list of dictionaries:

Python CSV tutorial:

➥➥➥ SUBSCRIBE FOR MORE VIDEOS ➥➥➥
Red Eyed Coder Club is the best place to learn Python programming and Django:

Python Openpyxl Tutorial: modifying Excel files | Python Excel automation

#pythonexcel #openpyxl #openpyxltutorial #pythonopenpyxl #pythonexcelautomation

[RedEyedCoderClub]

What video should I make next? Any suggestions? *Write me in comments!*
Follow me @:

Help the channel grow! Please Like the video, Comment, SHARE & Subscribe!

[RubenRodriguez-jxsc]

Just what I was looking for!! THANK YOU.

[fsyfgqi]

Thank you for the detailed video lesson, now I understand what's what, thank you again for your efforts.... helping people understand !

[olyfomina]

You are a wonderful person, you do such useful and very necessary video lessons, Thank you very much!!!

[houlvpd]

thank you for your efforts to help people with very interesting and useful information!!!

[darkgll]

Thank you! That's a brilliant tutorial!

[kostya]

Cool video tutorial on Python Openpyxl.

[bilalmsd]

how to add the data in the existing name table 'source', I tried to add the data to the named table 'source' but later when I open the file data is there but named table "source" isn't there anymore but data is. I need named table 'source' as well. how can I do that ?

[fwodcgs]

Thanks for the video... This week I will definitely need your video hint!

[docmalc]

I would like to give a BIG THANK YOU for this video.
Certain parts were tough to understand due to accent but thats what captions are for =)
You really did a great job with this video and how you explained things... again thank you, this video saved me!

[lisw]

An excellent guide. there is a lot to learn! accessible and understandable is class.

[jpdpmeh]

The video is great! It was interesting.👍👍👍

[zaynmunshi]

Is it possible to update the cells dynamically use iter_row ? I have a for loop that iterated between a min_row and max_row. The problem is that when I print (row[0]), it correctly prints the value of the first cell in each row between the selected min and max. But i want to now use the same for loop with iter_row to dynamically update the value of row[0] in each row between the selected min and max. Thats where my code is failing. Any help will be much appreciated.

[BesteFakoglu]

Thank you so much for this informative video! I tried to update also the columns via "enumerate" but it didn't work since the index always becomes zero. Do you know how to change also the columns?

[kostya]

Thank you very much for the interesting and informative video.

[kostya]

Thanks a lot for the video tutorial, it helped a lot.

[acerswift]

Does openpyxl library working without installed MS Office or OpenOffice?

[abdulaimohamed]

Great stuff!
How do I dynamically select a range and pasteSpecial - make its values equal to itself

import openpyxl

sheet = wb['Sheet1']

names=sheet['A']

for cellObj in names:
val = str(cellObj.value)
if val[0] == "=":
#print(val)

excel.Range(dynamic range).Select() #PART I WANT TO SELECT IF TRUE


THANKS!!

[kushbaba]

How can we write in columns first then rows?

[shivshankervijikumar]

Is there a way password protect an excel file using openpyxl