Installing PyXLL, the Python Excel Add-In

Tutorial showing how to install the PyXLL add-in for Microsoft Excel.

PyXLL is an Excel add-in that integrates Python into Excel, allowing Python to be used as a complete replacement to VBA.

[MedinaZyzz]

Just find you channel today, you have great content! you definitely deserve more subs. Hope to learn a lot from you channel. Cheers.

[donaldli]

The product is very cool but it doesn't seem to tackle a pain point imo.

I guess we can divide the traditional VBA/Excel use case into two groups:
1. strong need for reliability: you are building a spreadsheet/add-in product for users who requires a very high level of compatibility. In this case, you can't really make use of the PyXLL unless your counterparties have it installed as well? Not to mention questions like which version of python/packages are you running.
2. weak need to reliability: need to automate something for yourself, then an integrated environment could work since Excel in this case works only as a database lol. But the issue then becomes how will this product perform when we have big data? Then you need a real database, and all these nice features you would (NLP for example as shown in his other message) is more toy than engineering, because you would still have to handle everything in python and Excel then becomes your front-end. The real bottleneck then becomes Excel itself.

I believe the product fit is quite a niche -- you are looking for someone who is an Excel power user, who is fluent in Python, and wants to make developments in Excel. I don't know... I think most Excel power users know how to code in VBA to start with. And even though we like Python for its syntax and toolkit, there's really no reason to over-stress the issue to switch between app. I mean I can basically split my screen with a spreadsheet and a Jupyter notebook. I guess the best feature is UDFs but the most likely circumstance I think someone would need is in finance and they already have all sorts of macros written for what is worth it.

[islamux]

I searched alot about somethin like this.
Thanks alot.

[mohamedfliss]

Does PyXLL has a free version with limited features?

[Pakalaakhil]

Kindly reduce the price range, so that you can increase the user base by an order of magnitude

[gianlucavillamaina]

Hello,
Great video thanks,
Just at 12:11, after running the pip install pyxll-jupyter and restart Excel the Jupyter notebook button doesn't appear for me . Is there any troubleshooting i may try?
Thank you in advance

[Caracazz]

How do I get some RTD cell saved value after opening the workbook?

[artix]

What is the difference between the modules PyXLL and Openpyxl?

[adammujtaba]

30 usd per month or 299 per year ? why the overpricing mates?. reduce the price mate to increase the users

[Briefklammer]

it is not working. when i type python in terminal i get my python 3.9 32bit and i have excel 32bit installed. When i activate the add-in (yes i did the executable thing right) excel breaks ("excel has problems with add-in) -.-

[Akbar-uxbc]

I have tried many times but Jupyter did not show up in the Excel tab. Please help.

[lyekahkit]

Not a very useful video.follow all the steps and nothing happen:(