Use Python to replace VBA in Excel

Did you know that you can completely replace VBA in Excel with Python?

Script and automate Excel using nothing but Python, and write macro functions (Subs) and worksheet functions (UDFs) using PyXLL.

PyXLL

Resources for VBA developers

[StarsLuis]

As a Python dev, I really do appreciate staying in 1 language for development, especially when I produce some of my reports in Excel using Python. Now it looks like I can also include "embedded Python" aka Excel macros written in Python in my reports! Excellent!

[Simaq]

Many thanks for this video. I wanted to study Python and since I use excel spreadsheets daily, I then switched to VBA about 6 days ago. This was because I was unaware that one could "import" PYXLL into excel. My main goal was learning Python since I'm interested in both Data Analysis and Machine Learning. Your video just switched me over to Python.
Once again, THANK YOU SO MUCH. I'm now a subscriber

[RS-txbu]

This is simply amazing! Having the power of Pandas, Numpy, lists, dicts, regex, requests, multithreading, ML, ... and the easier than VBA Python syntax ... ALL now available inside Excel. I hope there will be something like this for MS Access as well someday. This is a game changer and you get the best of both worlds.

Some wise man once said: "Learn a new language, get a new life."

Hope you keep making many more videos like this.

[yacinegacem]

One of the many: "Thank you!"
Finally we got Python presented in Excel itself. Basically a hurdle less to embrass Python.

[gokulnaththeboss]

Dude there is a market demand where u can use python with excel in area of auditing /accounting where no one is teaching. I hope u start a series a based on those topic which would be so useful

[byteseq]

1. VBA does not usually index from 1 !

2. This is still miles from being as convenient and shareable as things made in VBA.

[dansam]

It is a very interesting extension... but I don’t get the reason why it is offered as subscription, and why it is so expensive.

[venusflytrap]

VBA is just fine - if it aint broke then dont mess with it - the final python structure is not easily readable - VBA is well suited to Xcel - it's inbuilt and right there to start using with no add in requirements or seperate packages and buttons or loading modules, all very time consuming and more things to go wrong - if microsoft ever drop VBA it will be the worst decision they ever make.

[HardieYe]

VBA is much much convenient. Doesn't need to install any plugins

[yeknafaskesh]

EXCELLENT - That was great and VERY well made. Thank you very much.

[NewStreamLine]

Interesting. But I'm familiar with VBA and I think I'll stay with it. No need to use many different tools to get one thing working.
Anyways, Python users might like that way of doing things.

[CosmicBarrilet]

Suscribed. Gonna curious inside the channel . Great vid, from a Python begginer.

[Riddingwithvivian]

Well done...excel might be the preferred platform for executing program code if it isn't already. That is good for me considering I have made a career around the program.

[excelmastervba]

WOW, this is awesome! 🚀🚀 I need to try that immediately 😄

[Kapildevkushwah]

I will give VBA priorty over python for excel use because u can record the codes even without knowing it.... We can not do recording in python we have to learn codes....

[GerryStilton]

I love the possibilities of PXLL but the pricing on the license is on annual basis and that becomes pretty steep at $240/ seat in a team of 10 and it stops working as soon as the licenses expire...got to make the pricing more attractive but at the same time I understand you're trying to make a living too. Great product with great use case but may be lower the pricing? Modify the licensing model? Tough call.

[DonAndress]

So exactly what is the advantage of using Python instead of VBA? Judging just by this video i can't see any. It's not even comfortable. It's like you do it because you can. I thought coding was supposed to be as easy as possible. Python in this case is not.

[romanverner]

This is amazing. Thanks for posting this!

[johnmcmanus]

Can't wait till they have this for SAP

[logic]

I see a lot of examples of using commands that reference changing the cells directly which is the slowest way of changing sheet data. I'm struggling to see how this is a replacement of VBA especially seeing how this is requiring an end user to use another type of program that they don't inherently have installed with windows whereas I can easily have buttons for them to run code in the spreadsheet of the same workbook I give them.