Introduction to OpenpyXL Library [ Python and Microsoft Excel ]

This is a quick introduction to "openpyxl" library.
You will be able to learn how to:

0- Introduction 00:00
1- Read from a single cell. 04:01
2- Read From Multiple Cells. 12:01
3- Create and Write on an Excel sheet. 19:22
4- Basic arithmetic operations. 30:33

Social Media
----------------------

Join this channel to get access to perks:

[williamthatsmyname]

Once again with a real world programming example. Thanks my dude.

[sheet-chat]

Thank you for your video; I've learned new knowledge. As I am currently working on something related to an AI assistant for spreadsheets, I found this library particularly useful. It helps in generating Python code to manipulate spreadsheets using AI. Thank you! 📊🤖

[metralios]

This tutorial is straight forward and informative. Thanks

[Netrouzt]

Sangat Mudah dipahami bagi Pemula!! Walaupun saya belum fasih berbahasa Inggris..
Melihat video ini, semua orang mudah paham.... Terimakasih dari Indonesia 🇮🇩

[vasanthkumarkallannavar]

Thanks Bek, any command that reads the charts which are plotted in the excel file read them and save them to the device as image or figure ? any help ?

[robertomijares]

when I want to run load_workbook, it tells me that there is a missing argument "id"

[asha]

Thanks Bek. It would be good to practice with a project

[amitsangwan]

Why did u import Workbook and openpyxl

Can't u only import openpyxl and use Workbook by openpyxl.Workbook?

[samirmishra]

You are great!:) Thanks for the tutorial.

[HomoSapiensSomos]

Thank you for the 'clear explanation. What can i do to read the result of a formula and not the fomula contained in the cell? I could not find a solution for this issue. I tried with the data_only set to True but it didn't work.
Would appreciate the tip. :D

[ISOPOINTQCS]

Thanks for tutorial. I have a question: is wb.active prepair clear new sheet ? If yes' how I open existing sheet without clearing it ? Thank you !

[dennydraco]

Great Video. Also wanted to ask you about where you got your command prompt graphics from.

[avgSE]

What font and theme do you use for VSCode?

[riazrr]

Hi dude is there a repo for this tutorial? thanks for the videos

[gbvtech]

hi, what theme are you using with posh theme terminal?

[Jriad]

by any chance are you egyptian ?
the names are screaming egypt

[adamdavies]

Many thanks!! Easy video ranking - P-R-O-M-O-S-M.