Python and Excel programming with OpenPyXL

Опубликовано: 28 Сентябрь 2024
на канале: AllTech

2,785

Here we will:
- load an excel with movies data;
- add a filter;
- add a formula;
- add a horizontal bar chart.

Support this channel, become a member:
   / @alltechpage

🔥 Udemy Courses LOW COST Coupons/ Cupões Cursos Udemy BAIXO CUSTO 🔥:
https://linktr.ee/AllTechProgramming

With Udemy Courses you get/ Com Cursos da Udemy você terá:
♾️ Full lifetime access/ Acesso Vitalício Completo
📱📺 Access on mobile and TV/ Acesso no celular e TV
🏆 Certificate of completion/ Certificado de Conclusão

📚 Useful books from Mike Driscoll 📚:
Jupyter Notebook 101: https://gumroad.com/a/635769971/rozo
Python 101: 2nd Edition: https://gumroad.com/a/635769971/ikdWt
Python 201: Intermediate Python: https://gumroad.com/a/635769971/aMtdh
Python 101 + Python 201: Intermediate Python: https://gumroad.com/a/635769971/KnQWc

wxPython Cookbook: https://gumroad.com/a/635769971/qdKKu
Creating GUI Applications with wxPython: https://gumroad.com/a/635769971/Eogsr

Pillow: Image Processing with Python: https://gumroad.com/a/635769971/LRAJQA

ReportLab: PDF Processing in Python: https://gumroad.com/a/635769971/bgQJY

◾ 💸 Donations 💸 ◾
Please consider giving a donation so I can improve the quality of this content that I made for all of you 😊
https://bit.ly/2Hdu9vb

⏰TIMESTAMPS⏰
0:00 Intro
0:21 Install OpenPyXL
0:39 Code
2:04 Create excel file
2:31 Insert data
6:34 Add a filter
8:18 Add a formula
10:14 Add a chart

Download source code at: https://drive.google.com/file/d/15-2-...

Know more:
https://pypi.org/project/openpyxl/
https://openpyxl.readthedocs.io/en/st...

Get data from IMDB:
   • Python Connect with IMDB - IMDbPY

Other videos:
Generate PDF with Python - Reportlab:    • Generate PDF files with Python and Re...
Generate PDF with Python - Reportlab - Create Table:    • Generate PDF with Python - ReportLab ...
Generate PDF with Python - Reportlab - Create Table - Part 2:    • Generate PDF with Python - ReportLab ...
Generate PDF with Python - Reportlab - Create Charts:    • Generate PDF with Python - ReportLab ...

Run Python Script from Excel VBA:    • Run Python Script from Excel VBA
Run Python Script from Excel VBA - Part 2:    • Run Python Script from Excel VBA - Pa...
Run Python Script from Excel VBA - Part 3.1:    • Run Python Script from Excel VBA - Pa...
Run Python Script from Excel VBA - Part 3.2:    • Run Python Script from Excel VBA - Pa...

Basic Python KeyLogger:    • How to do a Basic Python KeyLogger
Convert .py into .exe:    • How to convert .py into .exe
Image to Text with Python - pytesseract:    • Image to Text with Python - pytessera...
Speech to Text with Python:    • Speech to Text with Python - Speech R...
Weather Forecast with Python:    • Weather Forecast with Python
Search Movie with Python - IMDbPY:    • Python Connect with IMDB - IMDbPY
Generate and Read QR Code with Python:    • Generate and Read QR Code with Python
Run JavaScript from Python:    • Run JavaScript from Python 💪😃👍
Run Python in Browser - Brython:    • 📌 Run Python in Browser - Brython 📌
Hide Text in Image with Python - Stegano:    • 📌 Hide Text in Image with Python - St...
HTML to PDF with Python:    • HTML to PDF with Python 🧨🧨🧨
Web Scraping with Python - BeautifulSoup:    • Web Scraping with Python - BeautifulSoup
Translate Text with Python - googletrans:    • Translate using Python - googletrans 👍
Convert Python 2 to Python 3 Code - 2to3:    • Convert Python 2 to Python 3 Code - 2to3
Face Detection with Python - OpenCV:    • OpenCV Python Face Detection - How to...
Run Python Script in LibreOffice:    • 📌 Run Python Script in LibreOffice 📌
Generate Excel with Python - xlwings:    • Generate Excel with Python - xlwings
RESTful Web Service - Hello World - Java Spring:    • RESTful Web Service - Hello World - J...

Playlists:
Python Pandas:    • Pandas
Python and SQL Server:    • Python and SQL Server
Numpy Exercises:    • Numpy Exercises
ASP.NET Web API C#:    • ASP.NET Web API

Follow me on Facebook
  / alltech-1089946481026048

Or Twitter
  / alltech34460651

#Python #Excel #openpyxl #office #programming #software #AllTech