Python and Excel programming with OpenPyXL

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: /channel/UCBGENnRMZ3chHn_9gkcrFuA/join 🔥 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-Pqls2d9Z4rGpdiK49Zt7BLz8Z9Uz/ Know more: https://pypi.org/project/openpyxl/ https://openpyxl.readthedocs.io/en/stable/ Get data from IMDB: /watch/svz7VPCdOzvd7 Other videos: Generate PDF with Python - Reportlab: /watch/QkwuSi-7RDZ7u Generate PDF with Python - Reportlab - Create Table: /watch/sxH4LBXCO3BC4 Generate PDF with Python - Reportlab - Create Table - Part 2: /watch/EzxbQCZi--rib Generate PDF with Python - Reportlab - Create Charts: /watch/wrMmGTw9ZcF9m Run Python Script from Excel VBA: /watch/w-hZV35CS4ZCZ Run Python Script from Excel VBA - Part 2: /watch/k9q_5aiv9Z4v_ Run Python Script from Excel VBA - Part 3.1: /watch/Mc1c6rWnEoPnc Run Python Script from Excel VBA - Part 3.2: /watch/4UyRdea0kkT0R Basic Python KeyLogger: /watch/4f-vWrnP4SAPv Convert .py into .exe: /watch/4B7bNYQCtfCCb Image to Text with Python - pytesseract: /watch/Y3U5SVICrD4C5 Speech to Text with Python: /watch/U2Pz32JH2fIHz Weather Forecast with Python: /watch/04VisBv4G9O4i Search Movie with Python - IMDbPY: /watch/svz7VPCdOzvd7 Generate and Read QR Code with Python: /watch/0wCPF249KQ29P Run JavaScript from Python: /watch/Q8pPpvBpjyBpP Run Python in Browser - Brython: /watch/kNmk5qwXNFdXk Hide Text in Image with Python - Stegano: /watch/0tsCLfJbXhIbC HTML to PDF with Python: /watch/IJcDgLo3u3m3D Web Scraping with Python - BeautifulSoup: /watch/o7HPqIk2nnJ2P Translate Text with Python - googletrans: /watch/AHPim8IkFRyki Convert Python 2 to Python 3 Code - 2to3: /watch/cn_693F4v0t46 Face Detection with Python - OpenCV: /watch/wlC7ZWmAUeFA7 Run Python Script in LibreOffice: /watch/sQWydro_fE3_y Generate Excel with Python - xlwings: /watch/g5HOLmLMvGsMO RESTful Web Service - Hello World - Java Spring: /watch/MexY8qlLkXRLY Playlists: Python Pandas: /playlist/PLOGAj7tCqHx_c5uWrZX4ykdujODcqczmQ Python and SQL Server: /playlist/PLOGAj7tCqHx9Add6MWzl_5Wbix9V1OjSx Numpy Exercises: /playlist/PLOGAj7tCqHx9eQjST2RV-_Py3EJHqRq0C ASP.NET Web API C#: /playlist/PLOGAj7tCqHx9n-_d3YKwLJr-uHkmKZyih Follow me on Facebook https://www.facebook.com/AllTech-1089946481026048/ Or Twitter https://twitter.com/alltech34460651 #Python #Excel #openpyxl #office #programming #software #AllTech

Category