Excel Automation With Python

[@K59911]

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 💪

[@flockz]

Nice video!! Thanks for aways sharing your knowledge with us. Hugs from Brazil 💚. Alternative possibilite: with pandas you can manipulate Excel too.

[@NeuralNine]

Thanks brother! :)

[@yvanleroux88]

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

[@CodingIsFun]

Yes, you could use VBA for this: Sub RunPythonScript() Dim objShell As Object Dim PythonExePath as String, PythonScriptPath As String ActiveWorkbook.Save ChDir ActiveWorkbook.Path Set objShell = VBA.CreateObject("Wscript.Shell") 'PythonExePath = """ Insert Path to Python EXE here """ 'PythonScriptPath = """ Insert Path to Python SCRIPT here """ objShell.Run PythonExePath & PythonScriptPath End Sub

[@yvanleroux88]

@@CodingIsFun Thx a lot ! Appreciate that (:

[@marcosoliveira8731]

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?

[@Ayushsaxena-iz4rt]

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

[@NeuralNine]

Take a look at the channel. I have uploaded exactly the video you are looking for a couple of days ago.

[@charan2446]

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++.

[@subhankarchakraborty3866]

U r too good brother😘😘😘😘

[@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?

[@tusam3643]

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

[@test555channel]

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

[@ThePakfairy21]

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

[@NeuralNine]

Give it a try ^^

[@ThePakfairy21]

@@NeuralNine I would love to but I am still a newbie in coding😅😅

[@dishangmehta4397]

Florian: Excel isn't a programming language. VBA: Am i a joke to you?!

[@NeuralNine]

VBA is a programming language. Excel isn't. But yes VBA is a joke to me.

[@zombiekiller7101]

Lol🤣

[@dgh25]

VBA has not been updated since 1997 (except for support for new Excel feautures). VBA lacks a lot behind when compared to modern programming languages, for example VBA cannot extend classes. The error handling is made by using labels, which makes "spaghetti" code. And so on. So yeah agree VBA is fun, but kinda also a joke. Even Microsoft is currently moving to Python as the default language behind Office. The founder of Python was hired by Microsoft in 2020. Also: VBA only works on Windows and Mac - no Linux. And using external refs and or ActiveX, makes it Windows specific. Not really what you want in a modern IT environment.

[@abhinavchoudhary6849]

Noice

[@NeuralNine]

:)

[@fus3n]

Make a tutorial on developing brains!

[@mountaindeserver]

I'm from Russia!!

[@NeuralNine]

👏🏻

[@dgh25]

Im so sorry.

[@OmarHosam203]

b.. buh... but im using linux

[@NeuralNine]

Well, Linux supports XLSX files as well ^^

[@charan2446]

Just use LibreOffice or OpenOffice. they both support Excel formats/

[@TejrajParab]

First here.

[@NeuralNine]

^^