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

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

@python-bits

3 жыл бұрын

Glad you liked it!

@nofussfixer

2 жыл бұрын

Did you finished your project by any chance yet?

Thank you Very helpful

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

Nice.

Really explained well

@python-bits

3 жыл бұрын

Glad you liked it

flawless victory

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?

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

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

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?

that Gender column!😃

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

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

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

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

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

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

@thisisamitrathore

2 жыл бұрын

did you try string strip?

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

please make a video on openpyxl real world project

@python-bits

2 жыл бұрын

Feel free to provide suggestions. We will try to cover it.

where is this data ?? daily data ?

@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