Running all of that Python on the cloud is genuinely hilarious. Can't even render a graph offline with a whole table of data stored locally in your excel file.
2:15 You underestimate what kinds of stuff get done inside of Excel by non-IT personell. Here an example: In my last year of school before University (guess Americans would go to college, I am not that familiar with your school system), the grades were listed in points from 0 to 15 (15 being best) for each half-year per subject plus the final tests. From the half-year grade you were able to choose two grades (can't be the same subject) which won't be used to calculate your average (I am going to name these "crossed grades" going forward. To help with that, one teacher of my school created an Excel sheet where you were able to put in all your grades and then calculates the best possible average while choosing the optimal set of crossed grades. To top it off, he even added the functionality to say that you don't want a specific subject to be used for crossed grades or want one specific one to be used for it via a drop down (or the default, automatic) and then calculates the best average based upon that. So yeah, some people do crazy stuff entirely with Excel.
Excel formulas are turing-complete, SPJ (one of the haskell gods) infiltrated into Microsoft and literally added lambdas to excel to make the world's most used programming language a functional one
I had to make a simple monthly timetable sheet that automatically excludes the weekends from a very visually informative calendar and next to it people would fill in which date at what time how many tablet computers they want to use which automatically updates the calendar so that we'd always know how much unused tablets we have at any time. If this was me a few years ago I would have tried to write an app for that but my superior requested it to make it on Google Sheets. It was actually quite easy to do in LibreOffice Calc and then share this timetable via Google Sheets. The best part is that it didn't take me long to do so and it's easier for my non-IT coworkers to understand as they already know how to "navigate in Excel"
Every time my professors let me use Excel for anything, they almost always end up regretting it. Am I going to graph that binomial? No, I am not, I have an Excel formula for that. That formula also gives me any level of immediate steps you could wish for, so go ahead. Ask me to show my work. I'll do everything but manual long division.
The great thing about this feature is that after Excel users will learn basics of Python (so they can use it within Excel), they will notice, that they can simply jump out of Excel completely and just use Python.
Yeah and then you need to actually look at the data and you jump right back out to excel. Some vscode extensions do a reasonable job of viewing csvs etc but it's all a little bit janky. Which excel also is, to be frank, but usually it's he best option when you need to view some tabular data.
Год назад+1
You are going to un-wish that before the monkey paw grants it.
that's my hope. i couldn't convince non programmers around me to use pandas instead of excel. maybe now they get to learn it and i can steer them away from Microsoft one step at a time
Actually python in excel sounds like it could be useful for me. I have largish data sets that i want to share and generate some graphs for. I use excell as most people i share with dont have jupiter books installed and everyone has excell installed. Grafana etc aren't an option due to restrictions on cloud usage for the data. Note: the xlsx files are genrated using xlsxwriter. So yes the concept is interesting. Oh and yes the target are engineers. Edit: ok forget it, cloud is a no go.
@@codewithshriekdj true but that limit is per worsheet, so if needed i can split it across worksheets. Also it isn't a limit in xlsx itself, just excell refuses to load it. So for my use cases it works well enough. Never meant it was for everyone.
@@codewithshriekdjexcel can store up to 1 millions rows and 16.000 columns. i am not sure how it compares to notebooks but it's larger than google sheets, which allows 5 million cells total
I'm studying to be a civil engineer and have a job on the side where I'm REQUIRED to do EVERYTING in Excel so my boss can understand it so I'm quite excited by this update since I'll be able to use some of my education at work!
The cloud aspect is why I immediately wrote off this functionality as nonsense. They'll probably try to make some sort of security claim but there are better ways to accomplish the same thing. As for the functionality if it was run locally it would be very cool for a lot of people. There are very advanced Excel users who work in environments where python wouldn't normally be available to them and who are very comfortable using existing excel features. They can massively benefit from this. Jupiter notebooks don't give you direct access to excel based data, this would allow you to cut way down on your testing and tweaking cycles over Jupiter if you're an excel power user. Not useful for people that only use Excel for basic things and not necessarily very useful for people comfortable with general purpose programming and / or Jupiter, but extremely useful for Excel power users. Another element I think you miss is the ability to have someone create a spreadsheet that uses python and then share it with a basic excel user who is able to effectively use it as an application.
@@wumwum42 I don't see it as much different from Macros. They really should restrict the packages that can be used or have some system of signing and allowing packages or something. I have a feeling something along these lines is what they'll use to claim putting it in Azure is a good idea. Of course if you're worried about MS telemetry they can put that into excel as a core element no need for python.
I love this. The terminal can be a scary place for true beginners. I would imagine many people get turned off by programming and computer science at this point. With Excel integration these people would get some nice exposure to a real programming language without the headaches of installing it and those packages locally. Hopefully this would foster some curiosity about programming and computer science for those people. I can also see this being nice for schools and non-coding businesses where users aren't allowed to install programs on their computers. Whether it's a good choice for the business to actually buy this is another conversation, but if I were a low-level employee I would love it. Though for intermediate to advanced users I don't think this is too helpful.
Interesting (actuary here). There are some things excel is really bad/slow at. Like filtering a table on multiple criteria. Or (since it doesn't have within formula variables) sometimes you have to perform calculations twice or more within the same excel formula. This can result in hilariously slow spreadsheets, particularly for array driven formula. Its really not hard to make a excel crash or freeze with less than a thousand rows of actual data because of the inefficiencies in the functions. Potentially python could help in these circumstances. And I'm sure there will be other niceties as well for complex queries, regex etc. Data visualisation is not actually that big a deal, its more just the extended power of ordinary functions that are the most intriguing to me But the criticism for executing on Azure is still valid
I'll tell you why you'd want this.... IT security departments. I've had to use portable python on a usb in locked down corporate environments, because your boss and the IT guy is going to roll their eyes when you say you want to be able to run python to automate data analysis on a corporate laptop.... So it's VBA or a hack, but this would give you access in a locked up environment. Just hope they don't look too hard and ask why the data ends up in the cloud.
something like this would have been great when i had to do data analysis for a bank(if it could be run localy). All i had was the Office environment and no external software could be used. Got the job done but was a major pain
I'm glad my take on this aligns with Prime's insanity. *Excel gets Python* Me: Cool! My boss will like what I can do with that! *It's all uploaded and executed on the cloud* Me: Oh FFS.
I wish that in 1998 I hadn't had Prime's attitude about what MS was up to and just embraced the suck. I would be living in a much nicer place right now, and it would be mine. My brain would have probably adapted to the worms by now and I probably would be happy and sedate.
Honestly this seems super nice. A while ago my friend was doing homework putting together a report for his algorithms class. He'd run 3 different sorting algorithms and had them all output number of comparisons and time to run different sizes of data sets to a csv file. It was pretty easy to get all that data into excel which was nice for formatting the tables, but the graphs would have looked a lot nicer if he could have made the visualization himself. So for any sort of reports that are intended to be read by someone else this could be nice since excel gives you an easy way to make the nice tables you need but then if you want more flexibility in visualizing that data you can do that too now. But like I don't know how often people need to submit reports that include tables of the raw data so maybe this will just be a nice tool for college students.
There's a company that Tris keeps shilling that makes an infinite canvas spreadsheet program with python support. I wonder if it has anything to do with the fact that it's written on rust?
Most people use spreadsheets for tables (not computation) but somehow when they send me a spreadsheet it always has embedded formulas and there's no easy way to get rid of them. Sometimes I'll click in a cell and the cursor turns into a nineteen-thirties style baseball glove. WTF WHY?
THE REAL REASON FOR THIS FEATURE...because in corporate world, you have to pass the spreadsheet off to people (read C suite, VP, etc.) who have _no_ concept of what's going on. They _love_ Excel, because it produces structured little tables of noise that help them manage things. Send your data to Microsoft? Not an issue. Businesses LOVE Azure. So, yes, it's like a Jupyter notebook, but it's just a table-based notebook that you can hand off to normies and then they can do stuff.
1:48 We don't, our bosses who refuse to use anything that isn't Microsoft because they're scared of opensource and proprietary software refuse to change, and also are scared of or too computer illiterate for Microsoft Access
I need to know which question prompted this enhancement: 1. "You know what Finance people would love!?" 2. "You know what Data Scientists would love!?"
I suspect it only works for office online or in Azure. Even if you can run code up in the cloud in azure how do you put proper security permissions around that not have the same problem with people opening VB files in Outlook that we had a few years ago? Have we not learned that lesson?
Imagine being in the business of making $. Contrast with Netflix “Hey guys share your account with other”. Years later , “Bitches it was just kidding now pay for that shit”
You mentioned Jupyter. Have you done a video on that? As a new programmer who trial/errors constantly it has been great. Just go cell by cell until it works.
Excel is still the backbone of so many small-medium sized businesses, it's scary 😅 "here we have our two dozen highly sophisticated Amazon order importers, manually hacking them into Excel from Amazon"🎉
This is more for average office workers who only dabble in programming to automate an office task. They don't want databases or anything "confusing". They want to ask chat GPT for a python script and copy paste it.
considering most of those companies will also be storing their data in microsoft sharepoint i don't know how running it in the cloud makes things any worse
Just two days before today i was informed to try to use excel with python in the team that i am in. I Just Know That they are thinking without telling me to from now show us everything in excel instead of giving a print of jupyter notebook which they think is better choice for showing the data of more than 5 million rows
NO, PLEASE NO! excel sheets were for non R&D. You know, people in sales and marketing and other departments I've never been in physically. With this, you know what's gonna happen? I already see the User Story and bug reports before me mentally. "This function we let R&D develop for us doesn't work anymore!" Yea, because you moved some stuff around. "Why doesn't this show the values properly?" Because freaking AZURE was DOWN right at the time you wanted to calculate your forecast of how much I HATE THIS
I was denied installing Python on my workstation at a previous job that used the M$ ecosystem. This STILL would not let me have that by running it all in the cloud, ffs...
"This sounds like React Server Components for Excel." If you made this into a tweet, half of the Reactivists on X would think it was high praise. "Your code does not run locally, but instead in Microsoft's Azure Cloud." Aaand Microsoft just EEE'd my desire to ever "upgrade" from Office 2016. The offices I've worked at would never send sensitive info like PII to Azure cloud just to run Python. Many of them are still running my very old VBA code because their computers and networks are so locked down for security reasons.
"why would you ever use this" The answer is, imo, because not everyone is a programmer. You make an excel spreadsheet, and basically anyone knows how to use it, programmers, finance people, marketing, whatever. You make a jupyter notebook, and only programmers will be familiar with it. So, it's not for normies, it's for non normies to make tools for normies.
This is for all those finance and other companies that still use excel and their workers have asked to use a programming language instead. Now the c-suite can just be like: boom here’s your programming language, let’s keep our excel based solution 😂😂😂
I love when programmers, the most out of touch people regarding anything IT related, try to pretend in the comment section, that they have a better idea about what people want then fucking microsoft.
This is wrong, but on this channel AWS good, Azure bad. Truth is they're all greedy corps and stop thinking one is better than the other. They're the same crap with slightly different SaaS offerings. MS are just ahead of the curve right now while Amazon are sleeping at the wheel.
@@imbalos technically true but just because something's market share is growing doesn't mean it is not failing. remember this is market share (Microsoft) and most of the time market share is not about developers.
the way jupyter requires you to run the notebook top to bottom is pretty shit. the way excel solves dependencies is a lot more intuitive imo. but observable has this already solved so…
Libreoffice Calc anyone? Ok, he did mention libreoffice. So, what about PHP instead of Python? VS Code is free until it is not! Give'um free stuff to lure them in. When they "byte" 😅, you got'um and they can not escape, and never throw them back into the water. Have a nice meal. They're cooked!
Visual BASIC? *hurk* Hang on, one minute. *hurk* I think I'm going to throw up. *hurk* Could you get me a glass of water? *hurk* "Excel will now support Python." Oh, that's _much_ better than a glass of water, thanks! Edit: Wait, wait, cloud computing only? *hurl* I need a Tums. The whole bottle, thanks. And maybe some pure ethanol, to wash down the emotional pain and go to forever sleep, that I may never see this Eldritch horror again. Lovecraftian horrors have _nothing_ on this monstrosity. Things that are absolutely strange in ways that the human mind is unable to comprehend; those are but an annoyance compared to the horror of recognizing every part of the monstrosity and knowing how terrible it really is.
Finally I can code my whole backend in Excel!
lord help us all
Doom in excel?
do it
Only if you run it in azure cloud.
Clearly, Microsoft is about to build a game engine onto Excell if they are adding Python.
doom in excel when?
lmao done ages ago@@ThePrimeTimeagen
@@Automatic-Diaphragm thats_the_joke.jpg
@@ThePrimeTimeagen already done ruclips.net/video/J2qU7t6Jmfw/видео.html
wait, I just realized it might be possible if graphic libraries work in excel
Running all of that Python on the cloud is genuinely hilarious. Can't even render a graph offline with a whole table of data stored locally in your excel file.
2:15 You underestimate what kinds of stuff get done inside of Excel by non-IT personell.
Here an example:
In my last year of school before University (guess Americans would go to college, I am not that familiar with your school system), the grades were listed in points from 0 to 15 (15 being best) for each half-year per subject plus the final tests. From the half-year grade you were able to choose two grades (can't be the same subject) which won't be used to calculate your average (I am going to name these "crossed grades" going forward.
To help with that, one teacher of my school created an Excel sheet where you were able to put in all your grades and then calculates the best possible average while choosing the optimal set of crossed grades. To top it off, he even added the functionality to say that you don't want a specific subject to be used for crossed grades or want one specific one to be used for it via a drop down (or the default, automatic) and then calculates the best average based upon that.
So yeah, some people do crazy stuff entirely with Excel.
Excel formulas are turing-complete, SPJ (one of the haskell gods) infiltrated into Microsoft and literally added lambdas to excel to make the world's most used programming language a functional one
I did some advent of code year up to like day 10 using only excel
I am a programmer, don't have that much excel experience.
The financial world commits straight warcrimes with what they build in excel.
I had to make a simple monthly timetable sheet that automatically excludes the weekends from a very visually informative calendar and next to it people would fill in which date at what time how many tablet computers they want to use which automatically updates the calendar so that we'd always know how much unused tablets we have at any time.
If this was me a few years ago I would have tried to write an app for that but my superior requested it to make it on Google Sheets. It was actually quite easy to do in LibreOffice Calc and then share this timetable via Google Sheets. The best part is that it didn't take me long to do so and it's easier for my non-IT coworkers to understand as they already know how to "navigate in Excel"
Every time my professors let me use Excel for anything, they almost always end up regretting it. Am I going to graph that binomial? No, I am not, I have an Excel formula for that. That formula also gives me any level of immediate steps you could wish for, so go ahead. Ask me to show my work. I'll do everything but manual long division.
The great thing about this feature is that after Excel users will learn basics of Python (so they can use it within Excel), they will notice, that they can simply jump out of Excel completely and just use Python.
not really, it will feel too cozy living in Excel boxes to leave it
@@Xblow23 you wish
Yeah and then you need to actually look at the data and you jump right back out to excel.
Some vscode extensions do a reasonable job of viewing csvs etc but it's all a little bit janky. Which excel also is, to be frank, but usually it's he best option when you need to view some tabular data.
You are going to un-wish that before the monkey paw grants it.
that's my hope. i couldn't convince non programmers around me to use pandas instead of excel. maybe now they get to learn it and i can steer them away from Microsoft one step at a time
excel is my favorite python IDE, f nvim
Actually python in excel sounds like it could be useful for me.
I have largish data sets that i want to share and generate some graphs for.
I use excell as most people i share with dont have jupiter books installed and everyone has excell installed.
Grafana etc aren't an option due to restrictions on cloud usage for the data.
Note: the xlsx files are genrated using xlsxwriter.
So yes the concept is interesting.
Oh and yes the target are engineers.
Edit: ok forget it, cloud is a no go.
Yeah, But It Can't Handle Larger Data Like More 100 Thousand Rows It has a limit and it's slower there. It Can't replace notebook
@@codewithshriekdj true but that limit is per worsheet, so if needed i can split it across worksheets. Also it isn't a limit in xlsx itself, just excell refuses to load it.
So for my use cases it works well enough. Never meant it was for everyone.
@@codewithshriekdjexcel can store up to 1 millions rows and 16.000 columns. i am not sure how it compares to notebooks but it's larger than google sheets, which allows 5 million cells total
Take a drink everytime prime says jupyter book and not jupyter notebook
Why waste time say lot word when few word do trick?
Why waste time lot word few word trick
y waste?
y?
?
I'm studying to be a civil engineer and have a job on the side where I'm REQUIRED to do EVERYTING in Excel so my boss can understand it so I'm quite excited by this update since I'll be able to use some of my education at work!
Fireship is a hilarious and informative channel and a must follow for any analytical person.
The cloud aspect is why I immediately wrote off this functionality as nonsense. They'll probably try to make some sort of security claim but there are better ways to accomplish the same thing. As for the functionality if it was run locally it would be very cool for a lot of people. There are very advanced Excel users who work in environments where python wouldn't normally be available to them and who are very comfortable using existing excel features. They can massively benefit from this. Jupiter notebooks don't give you direct access to excel based data, this would allow you to cut way down on your testing and tweaking cycles over Jupiter if you're an excel power user. Not useful for people that only use Excel for basic things and not necessarily very useful for people comfortable with general purpose programming and / or Jupiter, but extremely useful for Excel power users. Another element I think you miss is the ability to have someone create a spreadsheet that uses python and then share it with a basic excel user who is able to effectively use it as an application.
Sharing tables with python codes will be a privacy nightmare... All these templates will be riddled with telemetry!
@@wumwum42 I don't see it as much different from Macros. They really should restrict the packages that can be used or have some system of signing and allowing packages or something. I have a feeling something along these lines is what they'll use to claim putting it in Azure is a good idea. Of course if you're worried about MS telemetry they can put that into excel as a core element no need for python.
This is why I don't market myself as a Python Dev. I don't want to be debugging spreadsheets the rest of my life.
I love this. The terminal can be a scary place for true beginners. I would imagine many people get turned off by programming and computer science at this point. With Excel integration these people would get some nice exposure to a real programming language without the headaches of installing it and those packages locally. Hopefully this would foster some curiosity about programming and computer science for those people. I can also see this being nice for schools and non-coding businesses where users aren't allowed to install programs on their computers. Whether it's a good choice for the business to actually buy this is another conversation, but if I were a low-level employee I would love it.
Though for intermediate to advanced users I don't think this is too helpful.
as a beginner excel is far more scarier than terminal
Its a good day when the Prime uploads a video
So 4/7 times a week
He's uploading everyday
Interesting (actuary here). There are some things excel is really bad/slow at. Like filtering a table on multiple criteria. Or (since it doesn't have within formula variables) sometimes you have to perform calculations twice or more within the same excel formula. This can result in hilariously slow spreadsheets, particularly for array driven formula. Its really not hard to make a excel crash or freeze with less than a thousand rows of actual data because of the inefficiencies in the functions. Potentially python could help in these circumstances. And I'm sure there will be other niceties as well for complex queries, regex etc. Data visualisation is not actually that big a deal, its more just the extended power of ordinary functions that are the most intriguing to me
But the criticism for executing on Azure is still valid
interesting, i just assumed excel excelled at doing those specific tasks already
You can use LET and LAMBDA functions to obviate the need for redundant calculations
The let function gives you in-formula variables
eg:
=LET(four,2+2,four^2)
will return 16
What's that FREEE reference?
Embrace
Extend
Extinguish
We may find peace between the python users in the dev team and the excel people in upper management
Seriously though if you're born to pyplot forced to pivot table this is a godsend
I'll tell you why you'd want this.... IT security departments. I've had to use portable python on a usb in locked down corporate environments, because your boss and the IT guy is going to roll their eyes when you say you want to be able to run python to automate data analysis on a corporate laptop.... So it's VBA or a hack, but this would give you access in a locked up environment. Just hope they don't look too hard and ask why the data ends up in the cloud.
well if they have any knowledge on networking you won't succeed
How big of a website could I build that has EXCEL as the server AND database?
YES
and frontend using excel online
something like this would have been great when i had to do data analysis for a bank(if it could be run localy). All i had was the Office environment and no external software could be used. Got the job done but was a major pain
Depending on the reason why no external software could be used, this is likely to not have been a usable solution either because of the cloud stuff.
EEE = embrace, extend and exterminate
I guess that reference is in regards to the Atom editor?
my financial planner is my db, my db is my ide, my ide is my cloud
i feel very soft in my micro
I'm glad my take on this aligns with Prime's insanity.
*Excel gets Python*
Me: Cool! My boss will like what I can do with that!
*It's all uploaded and executed on the cloud*
Me: Oh FFS.
I wish that in 1998 I hadn't had Prime's attitude about what MS was up to and just embraced the suck. I would be living in a much nicer place right now, and it would be mine. My brain would have probably adapted to the worms by now and I probably would be happy and sedate.
I think this is awesome because now I can apply python implemented filter over my engine pressure samples
kalman filter here we come
great to see the greatest DB ever made to get a python integration!
Honestly this seems super nice. A while ago my friend was doing homework putting together a report for his algorithms class. He'd run 3 different sorting algorithms and had them all output number of comparisons and time to run different sizes of data sets to a csv file. It was pretty easy to get all that data into excel which was nice for formatting the tables, but the graphs would have looked a lot nicer if he could have made the visualization himself. So for any sort of reports that are intended to be read by someone else this could be nice since excel gives you an easy way to make the nice tables you need but then if you want more flexibility in visualizing that data you can do that too now. But like I don't know how often people need to submit reports that include tables of the raw data so maybe this will just be a nice tool for college students.
There's a company that Tris keeps shilling that makes an infinite canvas spreadsheet program with python support.
I wonder if it has anything to do with the fact that it's written on rust?
Can you name it?
Excel rules the world dude. Every corporations goes through 4-5 layers of excel spreadsheets before the year end!
Most people use spreadsheets for tables (not computation) but somehow when they send me a spreadsheet it always has embedded formulas and there's no easy way to get rid of them. Sometimes I'll click in a cell and the cursor turns into a nineteen-thirties style baseball glove. WTF WHY?
THE REAL REASON FOR THIS FEATURE...because in corporate world, you have to pass the spreadsheet off to people (read C suite, VP, etc.) who have _no_ concept of what's going on. They _love_ Excel, because it produces structured little tables of noise that help them manage things. Send your data to Microsoft? Not an issue. Businesses LOVE Azure. So, yes, it's like a Jupyter notebook, but it's just a table-based notebook that you can hand off to normies and then they can do stuff.
What's the problem on making .xlspy that has venv baked in
1:48 We don't, our bosses who refuse to use anything that isn't Microsoft because they're scared of opensource and proprietary software refuse to change, and also are scared of or too computer illiterate for Microsoft Access
I need to know which question prompted this enhancement:
1. "You know what Finance people would love!?"
2. "You know what Data Scientists would love!?"
I suspect it only works for office online or in Azure. Even if you can run code up in the cloud in azure how do you put proper security permissions around that not have the same problem with people opening VB files in Outlook that we had a few years ago? Have we not learned that lesson?
Fireship + Primeagen, great combo
Primeship or Fireagen
Finally i can transfer my spreadsheets from google sheets using python
The moment I'm asked to write Python in Excel I'm gonna fucking quit
And just like that... Python recovered its natural place, and data "scientists" their proper titile::BA
Imagine being in the business of making $. Contrast with Netflix “Hey guys share your account with other”. Years later , “Bitches it was just kidding now pay for that shit”
Everytime you said Jupyter BOOK, I cried a little😅
1:45 it’s worse because it’s “in the cloud”
this is setting up for mojo in excel. Any expense will be in a tiered pricing for O365.
You mentioned Jupyter. Have you done a video on that? As a new programmer who trial/errors constantly it has been great. Just go cell by cell until it works.
There have been third party excel plugins to use Python in excel some free and it’s local.
the look of disappointment, I mean it is just purrfect!!!!! 3:45
when excel got python
you don't realize
python also got excel
Cool, now I can send my colab scripts to the numpties that refuse to move to Google Sheets
Does this mean, I can build my entire backend app and upload it to github as an xlsx file?
shhh don't give them ideas
4:57 - 5:45, dope, 🤣👏🏼👏🏼👏🏼 beautiful
Great now I'm gonna get excel course ads whenever I search with 'python' in the keywords
I mean, the moment you open your data in excel, you already gave your data to them
7:05
Just use Polars and Rust if it runs more than every once in a while.
It’s for the normie manager to ask the programmer to do it, because he heard it could be done and he tried but it didn’t work.
Excel is still the backbone of so many small-medium sized businesses, it's scary 😅 "here we have our two dozen highly sophisticated Amazon order importers, manually hacking them into Excel from Amazon"🎉
Coding in Excel could be disaster for debugging, that reminds me of MS Powerpoint guy that try to make it IDE.
This is more for average office workers who only dabble in programming to automate an office task. They don't want databases or anything "confusing". They want to ask chat GPT for a python script and copy paste it.
I'd love to see you 2 guys in the same room
As someone that is forced to use azure at work this video is giving me ptsd. Good video.
for me its the other way around I use python to make excel sheets lmao
God your good MS has your private data and we going to charge you more
Excel now feature compatible with LibreOffice . . .
considering most of those companies will also be storing their data in microsoft sharepoint i don't know how running it in the cloud makes things any worse
All PhD candidates will jump for it.
nobody joined the developers chant 🤯
whatever cool tools you have. the world will always run on excel and wordpress.
Just two days before today i was informed to try to use excel with python in the team that i am in. I Just Know That they are thinking without telling me to from now show us everything in excel instead of giving a print of jupyter notebook which they think is better choice for showing the data of more than 5 million rows
4:15 Of course it's for your own safety. 😶🌫
NO, PLEASE NO! excel sheets were for non R&D. You know, people in sales and marketing and other departments I've never been in physically. With this, you know what's gonna happen? I already see the User Story and bug reports before me mentally. "This function we let R&D develop for us doesn't work anymore!" Yea, because you moved some stuff around. "Why doesn't this show the values properly?" Because freaking AZURE was DOWN right at the time you wanted to calculate your forecast of how much I HATE THIS
I was denied installing Python on my workstation at a previous job that used the M$ ecosystem. This STILL would not let me have that by running it all in the cloud, ffs...
"This sounds like React Server Components for Excel."
If you made this into a tweet, half of the Reactivists on X would think it was high praise.
"Your code does not run locally, but instead in Microsoft's Azure Cloud."
Aaand Microsoft just EEE'd my desire to ever "upgrade" from Office 2016. The offices I've worked at would never send sensitive info like PII to Azure cloud just to run Python. Many of them are still running my very old VBA code because their computers and networks are so locked down for security reasons.
Micro and Soft... I wonder what that could be?! Right, boys?!?
"why would you ever use this"
The answer is, imo, because not everyone is a programmer. You make an excel spreadsheet, and basically anyone knows how to use it, programmers, finance people, marketing, whatever.
You make a jupyter notebook, and only programmers will be familiar with it.
So, it's not for normies, it's for non normies to make tools for normies.
Plus I wonder if a familiar environment + not needing to worry about setting up environments/dependencies could make this a gateway drug for some
@@sabrinapyles563 probably, sounds like javascript, trash language, but used everywhere because it is familiar to so many people
Exactly!
All you spreadsheet are belong to us!
This is for all those finance and other companies that still use excel and their workers have asked to use a programming language instead. Now the c-suite can just be like: boom here’s your programming language, let’s keep our excel based solution 😂😂😂
I remember when this news dropped last week, the msft dropped. Sell when news, buy when rumor....LOL
Its for when i am at work but i cant use python because pf company policy but can use excel and they still what sick graphs
DEVELOPERS DEVELOPERS DEVELOPERS
I just died a little watching this
Microsofts Pylance LSP only runs in studio now…. That sucks
I was thinking this was actually kinda cool until I heard "Azure"
I love when programmers, the most out of touch people regarding anything IT related, try to pretend in the comment section, that they have a better idea about what people want then fucking microsoft.
I kind of like Azure but you know a brand or product is failing if you force it to something that don't need it.
their market share is growing though
This is wrong, but on this channel AWS good, Azure bad.
Truth is they're all greedy corps and stop thinking one is better than the other. They're the same crap with slightly different SaaS offerings. MS are just ahead of the curve right now while Amazon are sleeping at the wheel.
failing?, azure pretty stable no?
@@EmperorAlles stable but failing. sometimes it is not easy to see something is failing
@@imbalos technically true but just because something's market share is growing doesn't mean it is not failing.
remember this is market share (Microsoft) and most of the time market share is not about developers.
At this point, everyone should just learn python.
Jupyter Notebook my friend, not Jupyter book
I still don't get the frEEE joke.
Makes sense considering the creator of Python joined Microsoft
When JDSL in Excell?
the way jupyter requires you to run the notebook top to bottom is pretty shit. the way excel solves dependencies is a lot more intuitive imo. but observable has this already solved so…
This sounds nearly as shit as electron desktop applications made for our field haha :D
I'm assuming this exists for the people who don't want to move away from Excel but need a bit more power.
Yea, but Microsoft already have PowerBI. Why not go all in with that platform? This seems like a solution searching for a problem to me.
@@spuzzdawgyeah I quite like power bi and it's a good product. I don't get this
wow I didn't expect today to be the day the "asmongold fan" arc resolved
The name is deserves a comment today
The conspiracy is true !
7:05 going through all that trouble not to use python😂😂, unironically it might still be faster to let javascript do the heavy lifting like you did
Libreoffice Calc anyone?
Ok, he did mention libreoffice.
So, what about PHP instead of Python?
VS Code is free until it is not!
Give'um free stuff to lure them in. When they "byte" 😅, you got'um and they can not escape, and never throw them back into the water. Have a nice meal. They're cooked!
Visual BASIC? *hurk* Hang on, one minute. *hurk* I think I'm going to throw up. *hurk* Could you get me a glass of water? *hurk* "Excel will now support Python." Oh, that's _much_ better than a glass of water, thanks!
Edit: Wait, wait, cloud computing only? *hurl* I need a Tums. The whole bottle, thanks. And maybe some pure ethanol, to wash down the emotional pain and go to forever sleep, that I may never see this Eldritch horror again. Lovecraftian horrors have _nothing_ on this monstrosity. Things that are absolutely strange in ways that the human mind is unable to comprehend; those are but an annoyance compared to the horror of recognizing every part of the monstrosity and knowing how terrible it really is.
I kinda learned python so that i dont have to use excel anymore
Nice, now I can confidently claim that I know Excel when I'm applying for some BS job.
Monthly subscriptions are exactly why I stopped using Photoshop.
Hey Siri, who is Satya Nadella?