Microsoft Excel just got Python

Microsoft Excel just added support for Python, allowing developers to code and run custom functions directly inside a spreadsheet. Let's take a first look at how Python support will work in Excel.

#python #ai #thecodereport

💬 Chat with Me on Discord

🔗 Resources

📚 Chapters

🔥 Get More Content - Upgrade to PRO

Use code YT25 for 25% off PRO access

🎨 My Editor Settings

- Atom One Dark
- vscode-icons
- Fira Code Font

🔖 Topics Covered

- Run Python locally in Excel
- Python excel overview
- How to get access to Python in excel
- Alternatives to Excel
- Microsoft's AI business strategy

[scpWyatt]

excel with python + chatgpt with python is about to give us an entirely new generation of "AI powered" start ups that make even less sense than before and I cannot wait

[hendrikd]

This will enable so many new and exiting ways for non programmers to get social engineered into executing untrusted code.

[xslashsdas]

How can Microsoft consistently amuse me in both good and bad ways at the same time

[nannan]

Managers everywhere celebrating that they can continue using a spreadsheet as a flat database instead of paying for a SQL developer: 🎉🎉🎉💃🕺💃🕺

[maxcohen]

I'm surprised Microsoft didn't just create a new code called "MSPython" that is _remarkably_ similar to... well, Python.

[LenardoDivina]

I only understand 10% of this channels content but I'm entertained 100% of the time

[velox__]

Wow, I can now mess up my pip dependencies directly in Excel! Amazing!

[marcomow]

Being a Google Apps Script developer for more than a decade, knowing the incredible potential it has, and how it is mostly unknown to the masses, it was a happy surprise to see it mentioned in such good terms, thanks Jeff!

[ismayilhuseynov]

Thank you, Microsoft. Because of this move, now we have a new video from Fireship

[matt.loupe.]

“Most developers would never admit it, but that game changing new app they are building probably could just be an Excel spreadsheet”
Real

[amosbennett]

This is probably the worst thing to happen since the inception of excel. The number of businesses running off the back of an unstable excel spreadsheet is horrifying.

[mey]

Perfect, just right when I finished my excel data analysis project at work writing thousands of python lines 💀

[BritishColumbianSikh]

Thanks for your code reports I always love your videos, been learning a ton from them for past few years #Respect

[cchutney]

Excel and Python are two of the three "can be used for everything, but absolutely should not" technologies of the world. The third is JavaScript.

[HoneyBadgerLikesYou]

Man they really had one of the biggest ideas for a Microsoft product ever - Python in excel - and implemented it in the worst, most crippling way possible - it has to run in the cloud.

Incredible

[SickMcNugget]

From what I remember, the third step is extinguishing any of the remaining bugs to improve the developer experience.

[trogdorstrngbd]

This is a great feature that will be very beneficial to those Excel users that are comfortable with a little scripting. However, I shudder at the thought of pre-existing, _already over-bloated Excel files_ gaining hundreds of lines of Python code strewn about various cells across multiple sheets.

[capsey_]

Obviously third step is "Examine", because after Microsoft's AIs examine the developer, it is easier to extingui- I mean, to empower them 💪

[nikitademir]

Quadratic also has been redesigning spreadsheets to be python native! And they run in your browser I think.

[hyperspeed]

The fact that it all runs in the cloud makes it a complete non-starter at my company. Everything has to be on the company network to comply with data protection laws.