Excel Automation With Python

In this video we learn how to automate Excel procedures using Python and openpyxl.

◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾
📚 Programming Books & Merch 📚

🌐 Social Media & Contact 🌐

[yvanleroux]

Is it possible to launch a py script using a macro ? The idea is to be able to refresh / update cells without quitting the excel file every time

[flockz]

Nice video!! Thanks for aways sharing your knowledge with us. Hugs from Brazil 💚.

Alternative possibilite: with pandas you can manipulate Excel too.

[K]

Hey man, nice video. I am always impresed how you always get your information to solve those problems. I study a mixture of economics and programming in germany. I already wrote little programms in different languages but i am still confused how to find the libaries i ned for my specific tasks and sadly it's more often than i like the case, that i don't know how to find the right things on stackoverflow, etc. Do you have any tipps especialy how to find and work with libaries for a medium entry beginner? Thanks a lot and go on with your nice work 💪

[marcosoliveira]

I´m using most shown here on my daily job. Well done!
I´m working with a lot of big excel files, which takes a lot of time for the programs created the dataframes that are needed do process data.
Is there a "fastest way" to create a dataframe from a excel file other than "pd.read_excel" that I normally use?

[garfield-pro]

I created a folder named Misc in Windows 7, then I renamed it to Misc.. and it disappeared. Any idea where it went?

[charan]

Good video!
can you make a playlist or videos on C++. Topics are same as what you did on python videos.
Ex: convert this video, python into C++.

[Ayushsaxena-izrt]

Hey it would be appreciated if you will make a tutorial on socket for beginners in python because i am struggling with the concepts of socket and i think you are best teacher
Thanks in advance

[tusam]

hey man, yfinance package is now working for Yahoo finance, run a pip --update

[testchannel]

How is this considered automation when you have to do x10 more steps for the same result.

[dishangmehta]

Florian: Excel isn't a programming language.

VBA: Am i a joke to you?!

[ThePakfairy]

Can we automate likes on Youtube, so that we could automatically like all of your videos.