Excel Now Has Python - And It's Awesome

Seems like it could potentially be very useful. For now, I'll stick with my XLOOKUPs and nested IF statements, but it might be nice if I'd need anything more than one ELIF.
It doesn't immediately seem like it replaces VBA and macros yet either, but I'd guess it's only a matter of time?

It's a shame about the extra cost, though.

why do you even want to use excel

I am required to use Excel and Python on their own on a daily basis during my PhD, and that this exists is my absolute worst nightmare coming true.

That was cool !! I had a question; does anyone know of a relatively painless way to “merge 2 .json bookmark files. ??

I currently have two individual bookmark files from Firefox’s browsers on different machines that I would like to merge as one file.

RegEx is the first thing I tried when I got the feature, haha.

imagine pygame in excel

What a waste of computing power to force everyone to run every piece of python code in the "cloud". You shouldn't have to pay an extra license just to run python code.

I'm not sure if I understand correctly ... this can be run only online? So ... all data are send to MS? Yeah! I'm wrong. No? O..O

Late response from Office to what Google offers many years ago, through JavaScript code, and all of it is natively, free, online, and more powerful. Please, Joe, make a video of it.

Can't wait until firefox has Python to change the url 🎉🎉🎉

Thanks Joe! Just wondering if it’s possible to use Python formulas in named ranges?

if all the actions are done on hyperV on microsoft servers, I wonder if you can see the ip. And if so, I have MANY crazy ideas what can be done.... Of course that would be big security hole.

btw now making games in excel will be much simpler.

One thing I've learnt during my programming career is that "eval is evil". I wouldn't use it, even if the code is running on a separate VM, there might still be vulnerabilities that could allow malicious code to "escape" it and do nefarious things into your host system.

Nonsense! This invites you to mix data and its analysis. As a professional data analyst, I can tell that this is VERY bad.

I just knew this was going to be really powerful once it debuted and here is why: A software language perform operations on strings of characters, including numbers which are considered strings with unique properties. All strings can be grouped into special sets and given unique properties, such as: Bool, Integer, Float, and so on. In other languages these are called (Data) Types. Individual Data Types can be further grouped together into a special set called a Class, Struct and or Structure which only have these unique data types as built-in attributes and or properties. The excel spreadsheet allows you to view the memory layout in a flattened manor. In a traditional programming language the cells would represent a CPU and GPU register, or auxiliary memory address. The reason this development paradigm is more powerful than a traditional programming language will become clear to the world with the introduction of AI (OpenAI's ChatGPT), and hopefully AGI in the upcoming releases.

Python 3.9.... no match-case :(

can it do pygame?

please do a vid aboujt tensorflow in exel 😆 - and i wonder if tkinter works in it

edit: match was added in 3.10, sry
base = xl("C6")
match xl("C7").lower():
case 'a': base *= 10
case 'b': base *= 20
case 'c': base /= 1/50
case _: base = 'Error'
base

Non-cloud virtualization (WSL, etc.) or WebAssembly-based Python are the best ways for non-cloud Python for Excel. Given how much issue macro security is for an average Office user.

That's a groundbreaking feature. I had troubles understanding excel script. Now everything will be different. Thanks for video btw.

Awesome feature but it would be more awesome if it installs the python locally 😊

This is super amazing. It's in a not super useful state right now, but the potential with this is so huge. VBA is completely impractical these days, so being able to use Python for stuff instead is so wonderful

If I cannot run the code locally I'm just straight up never using this feature. Just make it like macros, where it has a specific file extension and downloaded files have to have Python explcitly enabled to actually run the code. Microsoft can make whatever excuses they want, but until I'm able to use the feature 100% offline it may as well not even exist in my eyes.

what a big scam. Surely a big ass company like Microsoft could figure out how to run it safely in your own computer, but yhe good ol' "safety concerns we could avoid force us to only offer this as a service instad of a product". Customers are paying regularly to not have the latest features. And they will be happy to throw more money at should come with what they already pay!

Imagine if your web browser forced you to pay a subscription to run every website's code in the browser's owner's server instead of your computer, for "safety concerns". While it's possible that exploits coild lead to the code being unsafe to run, it has never been a big enough concern to not let users run the code in their own machine.
This feature is bullshit and it hurts to know that people won't see the scam and will happily pay for it.

Python is a cancer that keeps spreading.

Having Python in Excel is cool but what would happen if malicious python code gets executed?

Superman + Captain America = Python in Excel

Can Excel-Python write and/or run Excel macros?

Make more videos like this.Make more videos on openings focused on product based companies.

Remember the PC? The Personal computer? For the first time one could do his/her own computing at home instead having to rent time to use the big mainframe computer at campus or university. The first pc pioneers were excited that they could finally do all the computing at home without having to pay per hour. And what are we doing now? Right, going back to the 60s where the computing is done on someone else his computer. What the bleep, micro transactions in excel functions, get out of here. Bring the P(personal) back in computing

IP Loggers bouta be crazy

edit: oh.
edit 2: OH.

When your late so you cant be top comment

so many competition. now a lot more people know how to code.

hope "only office" will also have this feature

I do not like the fact that it needs to run in the Microsoft cloud. This should really be optional (in that case it would be really great). That's already a disappointment to me.
But that is because I dislike that whole thing where they are forcing you more and more to use cloud services in general. But that's my freedom oriented mindset. Feel free to disagree with me of course. But hopefully some kind of open source project will take over the idea to use this thing for free and on your own system.
It's not that am not against cloud, but I consider it a mistake that it's made into the only option, especially when it comes to having to rely on large anonymous companies like Microsoft and Google.

Only good part is matplotlib

Finally a good excel update.

Also I find it funny how he casted a string as a string :)

Thanks!

You should totally do a Python course, I'd take it.

I could see this being big for teachers. Even compared to Jupyter notebooks, The way this allows you to see your entire program state at once and mix and match more familiar Excel functionality with less familiar code could be huge for someone trying to teach computer science in a middle school or high school setting

So, how much are they going to charge for the extended capability?

HOLY!?

Why didn't they just spin up a small vm locally when you start Excel if you enable the feature?

It seems like it's running some sort of Jupiter lab instance in the VM and the way cells run is very similar to a .ipynb notebook.