Hands-on Python Openpyxl Project

This video covers the complete excel automation project using the python openpyxl package.

You will learn:
1. How to handle multiple excel files in openpyxl
2. How to merge data using openpyxl
3. How to customize row/column iterations
4. How to find and update specific data
5. How to create custom excel report

[Hakeem]

Very helpful.
I liked that you are facing challenges then going back and fixing them.
Thanks for a very impressive work.

[mok]

great job, I am a beginner in python and I started finding resources for automating excel though python. However, all of the youtube sugestion was just to give a concept of how to read write excel functions in openpyxl and does not help us to go through a project like the above.

I found your content really helpful and it has speed up my learning so much, hopefully you come come out with more project based automations for excel such as financial reporting, charting, and pivot. Looking forward to your new excel automation content.

it is a great job and it really differentiate yourself from the other openpyxl youtuber. Hopefully I can begin to really automate my complicated excel spreadsheet in the workplace by this week. 13 Jun 21, will post an update here if i am able to complete my automation project in excel

[DanielOkoronkwo-mi]

Hello, I would also like a link for the daily and master file

[Himanshu-csti]

Hello can you send me the link for daily and master file

[jeff]

is there a way to auto highlight a row? so once you create a workbook, can you generate a highlight on specific rows so that the user of the workbook knows where to look quickly?

[Magic]

When finding matching ID between daily_sheet and master_sheet and iterating over each row to create a new list of the "altered data" to append to new excel sheet "daily_report_send" the appended data that was matched using the IDs appears to be in ascending order. Therefore each row in daily_sheet vs daily_report_send are not in the same order. Curious if there was a particular reason for this? Example: id 72, 5, 54, 10, 9 appears as 5, 9, 10, 54, 72 in daily_report_send

[manivannan]

Hi bro, please help to automate more scenario and post video

[buck]

hello, i'm a beginner as well, and i really enjoy Python Bits videos. i have a problem though, the code works great, up to arow no 89...then it goes blank, then it imports data into row no 91, then...again blank till the end of the document (more than 2000 rows)..where am i go wrong? thx

[buck]

PS: i checked my data now..the results are scrambled..eg: i want to import data from sheet 2 in sheet 1, for each row where i have code 200, to bring value x, for code 300 bring value y...in my file i have about 300 people associated with code 200, 300 people associated with code 300, etc; even at consecutive rows with the same code, it brings different values.. why?

[Himanshu-csti]

Hi please create a video in which you use filters then delete some data and copy remaining and pasting it in new sheet

[emirgymnkd]

can you share these excel files with us so we can write the codes with you at the same time?

[sarcothegenerous]

great work!!!
Please can somebody tell me how to remove double quotations from xlsx file using openpyxl

[shaikhahmedbd]

hey! nice video! Could you please share the excel files? so that we can practice!...

[javedj]

please make a video on openpyxl real world project

[avishkafernando]

if you give your
document that's really helpful for practic

[nisrinebenyagoub]

@pythonbits please do you have any Other social média or you have a gmail, i have a question for you please, thank you so much