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

@ungarbagebin

11 ай бұрын

you summed it up in the most pythonic way sir

@HoNow222

11 ай бұрын

exactly, a shitload of shit is out there awaiting

@MrAlanCristhian

11 ай бұрын

I can't wait to see "investors" losing money with some shitty services that does nothing, solves nothing, worth nothing, but they are cool and techy

@shivanshsingh8173

11 ай бұрын

Ya one of those apps which use "AI, ML" to calculate your BMI.

@lawrencedoliveiro9104

11 ай бұрын

Just leave out the “Excel” part.

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

@flyingsquirrel3271

11 ай бұрын

Hahaha ransomware goes brrrr

@shashu1999

11 ай бұрын

The code is ran in the cloud in a sandbox. I don't think it can affect your pc

@julianomoura3631

11 ай бұрын

@@shashu1999 but it can get data from the spredsheet and send to a remote address. Spredsheets may have lots of sensitive information about companies.

@adamestrada7610

11 ай бұрын

@@julianomoura3631 that's going to completely depend on what features of Python Microsoft allows to be executed in the cloud. I'd imagine any native functions or packages involved in data transfer (i.e. database connections, email, etc) are going to be excluded or disabled in the runtime. Not to say hackers won't find a workaround (they figured out how to do that with Power Query, a read-only ETL language in Excel), but having the actual execution take place in the cloud is going to be a very different challenge for hackers.

@owenswabi

11 ай бұрын

Hahahah

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

@nannan3347

11 ай бұрын

> but it crashes when I open it Does it crash *every* time you open it? 💃🕺💃🕺🎉🎊

@letopizdetz

11 ай бұрын

@@nannan3347 'it works on my machine'

@dinoscheidt

11 ай бұрын

Best of both worlds: Unmaintainable imperative excel Formulars with none unit tested untyped python code. Perfection.

@NessHypegaming

11 ай бұрын

LMAO im laughing but crying on the inside.

@martingamper6435

11 ай бұрын

MS Access ( and its 2GB file size limit it is)

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

@KosstAmojan

11 ай бұрын

Because there is nothing more critical to the success of a business than consistency.

@lynnk.7587

11 ай бұрын

I have love/hate relationship with Microsoft as a software developer AND media designer. I love .NET and C# and it's been and still is my strongest field in software development (since I began with VB and .NET as a kid), and Microsoft nailed it with .NET Core and their ideas, but some fields are just plainly fucked as if the devs had no idea on how the framework is supposed to be (see Blazor and the .NET 8 changes, introducing a completely new structure out of no where)

@jirehla-ab1671

11 ай бұрын

​@@lynnk.7587the aubcription model lol

@FireSiku

11 ай бұрын

@@lynnk.7587 I remember in the early 2015 when Nadella had just started the ramp up to change Microsoft from the old "Lets buy things to kill them" to the current dev-friendly approach. They announced Visual Studio Code and I was just floored. "What do you mean when you says its a free editor without 40% of screen estate taken by an obnoxious Ribbon UI? AND it supports Linux and Mac? Ha! Thats def. a late april fools joke". Followed by them actually realeasing it and being left dumbfounded a second time going "What have you done with Microsoft?!" And now I just thought back at the fact that Github was bought by Microsoft nearly FIVE years ago... and yet it still looks and feels like Github.

@yash1152

11 ай бұрын

same lol

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

@guyvleugels8507

11 ай бұрын

... PSA... PyScript for Applications... The horror.

@NizaSiwale

11 ай бұрын

@@guyvleugels8507They succeeded with C# which is just a Microsoft version of Java

@4.0.4

11 ай бұрын

Or P# to make it clear it's a whole new, legally distinct language.

@superslash7254

11 ай бұрын

Oh no, why do that? Just come up with your own extensions to python that slowly become more and more incompatible with the original language and all other packages.

@mattimusmattrime

11 ай бұрын

Elastic Python Runtime powered by AWS...

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

@LuisSierra42

11 ай бұрын

Are you not a programmer?

@AmpersAndAI

11 ай бұрын

inaccurate content often gain the most traffic

@noctrl007

11 ай бұрын

Same lol, I ain't a programmer 😂

@LenardoDivina

11 ай бұрын

Nope .. 3D artist @@LuisSierra42

@snovbird

11 ай бұрын

@@AmpersAndAI well then tell us what was inaccurate in this video, and do not say everything, I want precise examples

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

@heroe1486

11 ай бұрын

Building a backend with excel is probably a shitty idea tho, for which advantage ? It's probably slower to figure out what to do and come up with "hacks" than learning some basic SQL which takes a day at most

@adamestrada7610

11 ай бұрын

@@heroe1486 fun fact, there's an ODBC driver for Excel so you can run SQL queries on your spreadsheets...not that you should.

@gadget00

11 ай бұрын

@@heroe1486 if the customer is using Excel as a backend AND frontend and it hasn't scaled out of control, then he doesn't either need SQL or your services for that matter. The minute the excel sheet gets corrupted or the data grows beyond the 65k lines, then you'll get the call

@k-c

11 ай бұрын

You only need one app for everything. A Spreadsheet.

@lawrencedoliveiro9104

11 ай бұрын

I think a Jupyter notebook would be far more flexible: each cell can hold as much or as little code as you like, and can produce multiple associated items of rich output - graphics, sound, video, maths, formatted HTML, plus interactive widgets to control same - interspersed with cells containing narrative text so your notebook can be self-documenting. And you can include code in other languages besides Python.

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.

@GeorgeMixalis

11 ай бұрын

Seriously, i imagine all the incredibly convoluted macro powered excel files , and now i imagine the python powered equivalent files that will come out of this.

@MasterChaoko

11 ай бұрын

@@GeorgeMixalis*Spiderman pointing meme*

@lawrencedoliveiro9104

11 ай бұрын

Once they realize that everything they do in Excel can be done better in Python+NumPy+Jupyter+Pandas+Matplotlib+all the rest of it, then Excel just becomes the shell you start to get to the other stuff. Microsoft will likely make some money off the crowd who are too dumb to realize that they can dump the Excel part and use the rest of it ... for free.

@ArunShankartheRealOne

11 ай бұрын

As developers, it is our duty to create problems today so that we can get paid to find a solution tomorrow. All hail the Spaghetti Code monster.

@Necessarius

11 ай бұрын

Nah.... At least the problem will. Be resolved by a computer instead of a single guy that reads the excel 8 hours per day

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

@adamestrada7610

11 ай бұрын

Not quite. It runs in an Azure cloud, meaning that whatever packages and versions will be available to you are only going to be the ones Microsoft approves. And if it's anything like the ol' MRAN R language repository (that Microsoft just shut down), you'll be two years behind the latest releases.

@julsmanbr8152

11 ай бұрын

Not really, and that's half of the point

@mitnick212

11 ай бұрын

@@adamestrada7610 Does Microsoft pay for that Azure instances or the customers pay ?

@GSBarlev

11 ай бұрын

​@@adamestrada7610Yeah, conda-main tends to run a bit behind conda-forge, which itself can be sometimes be a point release behind PyPI. But it's usually not quite "apt repository" level of staleness.

@adamestrada7610

11 ай бұрын

@@GSBarlev Totally, but if I know Microsoft as I do, they'll probably be running package versions at least six months behind because they'll need to ensure that those packages don't conflict with core Excel functionality. This is similar to Power BI where only Python 3.7.7 is currently supported, which was released all the way back in 2020

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

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!

@larrymoose15

11 ай бұрын

I've been looking for GAS jobs for a few months now, any suggestions where I can find some opportunities?

@petros_adamopoulos

10 ай бұрын

Good thing the masses don't use it, because like anything google, it can be discontinued at anytime, and eventually will.

@RedHair651

6 ай бұрын

My job has the option to use Apps Script and I was planning on giving it a go, but I didn't know there were people working only in it :0 I thought it was a minor thing for internal tools

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

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

@lawrencedoliveiro9104

11 ай бұрын

They want to make money from it.

@petef15

11 ай бұрын

They'll be using that to further train ai.

@thisaintmyrealname1

11 ай бұрын

Exactly. Wtf. I was so excited for this, to pitch python to my non-programmer friend that manually processes a lot of data in excel sheets at work. But now i find out about this cloud shit .....😤

@HoneyBadgerLikesYou

11 ай бұрын

@@thisaintmyrealname1 same for me. Would’ve loved to tell some people I know about this. What’s the point of a tool that can’t be used locally. Cloud is supposed to provide infrastructure and management benefits, not act as a paywall to real features. Dumb.

@Kortex42

11 ай бұрын

​@@HoneyBadgerLikesYouyeah like wtf

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

@Flame1611

11 ай бұрын

Same 🥲

@the_biggest_chungus7508

11 ай бұрын

Oof

@k-c

11 ай бұрын

Your code can run locally though.

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.

@MickenCZProfi

11 ай бұрын

Never underestimate Atwood's law.

@vectoralphaSec

11 ай бұрын

i would say javascript is the worst out of those 3.

@cchutney348

11 ай бұрын

@@vectoralphaSec I Agree.

@YouAreTheRaidBoss

11 ай бұрын

Why?

@RunawayYe

11 ай бұрын

I think someone is trying to make a kernel in javascript on a dare.

Man, your videos are next level! Fantastic work!

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.

@Wanted797

11 ай бұрын

“I need a new laptop. Mines too slow at opening things…”

@lovis1188

11 ай бұрын

if i was still working for my shitty old boss, i would probably be about to automate their whole spreadsheet with python

So much info in a 3 minutes video. Amazing bro 👏🏽👏🏽👏🏽

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

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

@midlander8186

11 ай бұрын

Well, extinguishing something. Not necessarily bugs, usually the competition.

Your videos are great ❤ Thanks 🙏

Welcome back! I hope you had a great summer ;)

Finally! I've been asking for this for years.

My day when your video drops out. ❤🎉

Awesome, now I can do machine learning while building my spreadsheet

I've been able to plug in Python commands to Excel before. It's great that MS have included it natively

I LOVE YOU FIRESHIP!

Never thought I'd see the day that Microsoft and Python would partner up, but just like with ChatGPT anything is possible these days.

@katrinabryce

11 ай бұрын

They hired Guido Van Rossum a few years back, so this was inevitably going to happen.

@awusacollins

11 ай бұрын

Guido currently serve as a distinguished engineer @Microsoft

@oh-yes_10-fps15

11 ай бұрын

windows uses some python scripts too

@HypnosisBear

11 ай бұрын

@@oh-yes_10-fps15 Wait really? That sounds intriguing... I used to think it was purely coded in c.

@ko-Daegu

11 ай бұрын

nothing to do with ChatGPT Microsoft brough Guido like 2+ years ago to dev python they dev 3.11 which was a great step

man this is such a huge win - I had to buy plugins back in the day to do this kind of work (7-8ish years ago), so its so nice to not need to anymore!

11 ай бұрын

Now you can give money to Microsoft directly 🎉

@jewpcabra666

11 ай бұрын

@ I mean yeah - but if company paying/u already have office then nbd 😂 also see it as a win because ppl with excel might now get into coding more

@AmpersAndAI

11 ай бұрын

While useful, this functionality involves pandas, not python

@Wyvernnnn

11 ай бұрын

If you can't run it locally, it's useless

Thank you Fireship for programming Python.

I find this incredibly awesome. Excel becoming more powerful and sophisticated is something with which I am wholeheartedly pleased to see. Love it or hate it, you can't deny the significant influence and usefulness of Excel.

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

@priapulida

11 ай бұрын

Quadratic is a web-based spreadsheet application that runs in the browser and as a native app (via Electron) [2]. It is an infinite canvas spreadsheet with built-in Python, SQL, and Formulas[1][5]. Quadratic is designed to enable users to pull data from its source (SaaS, Database, CSV, API, etc) and then work with that data using the most popular data science tools today (Python, Pandas, SQL, JS, Excel Formulas, etc) [2]. Quadratic has several features that make it unique, including: - Multi-line formulas: In Quadratic, you can expand your formulas to as many lines as you need[1]. - Python library support: Quadratic has Python library support built-in, allowing users to bring the latest open-source tools directly to their spreadsheet[1]. - Powerful AI integration: With GPT 4.0 powered autocomplete for data, formulas, and code, users have a powerful spreadsheet companion[1]. - Infinite canvas: Unlike other spreadsheets, Quadratic has an infinite canvas (like Figma), allowing users to pinch and zoom to navigate large data sets, and everything renders smoothly at 60fps[3]. Here's a summary of some of the key features of Quadratic: - Infinite data grid with Python, JavaScript, and SQL built-in[2]. - Data connectors to pull in data from various sources[2]. - Multi-line formulas and Python library support[1]. - Powerful AI integration with GPT 4.0 powered autocomplete[1]. - Infinite canvas for easy navigation of large data sets[3]. Quadratic is available for download from its website[1], as well as from GitHub[2] and the App Store[6]. Citations: [1] www.quadratichq.com [2] github.com/quadratichq/quadratic [3] news.ycombinator.com/item?id=35456509 [4] sourceforge.net/projects/quadratic.mirror/ [5] www.producthunt.com/products/quadratic [6] apps.apple.com/us/app/quadratic-master/id351899924

@katech6020

11 ай бұрын

yes they run using Web Assembly

awesome....now Excel will be fun to work with

Will be interesting to see how this goes!

I just love Excel and it's always fun to see what new is coming

@Kenionatus

11 ай бұрын

Damn, that looks like all I ever wanted from a spreadsheet program.

@lawrencedoliveiro9104

11 ай бұрын

Think of this as Python+Jupyter+Pandas+etc embracing and extending Excel. Guess what happens next ...

@Don-fw3nv

11 ай бұрын

​@@lawrencedoliveiro9104what?

@cinderwolf32

11 ай бұрын

​@@Don-fw3nvyou heard the man, you have to guess

@Crossfirev

11 ай бұрын

@@cinderwolf32 what if that was his guess? 'what?'

I love your code reports for three reasons, but I forgot which is the third one

@1996Pinocchio

11 ай бұрын

What are the first two?

They deserve eachother.

this is going to be a game changer

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.

@billmoney1

18 күн бұрын

USA #1

Python framework called Excellent coming soon.

I was about to say, this would be a great replacement for my sql tables but nah, if it's not local then there's no point

Wow, thats amazing!

I got scared as hell😂😂😂

@TriforceofShadows

11 ай бұрын

Me too. 😅

@d3xdae465

11 ай бұрын

Same 😅

@viraldoseoftiktok3714

11 ай бұрын

I read "Microsoft acquired Python" 😢😂

@viraldoseoftiktok3714

11 ай бұрын

He changed the title 😂😂😂😂

The Excel championships are gonna be fire next time they happen 🔥🔥

That is gonna be so awesome! Imma gonna go nuts.

There is already something similar in excel with Javascript (Excelscript) but obly available to companies and student accounts (my case) if I'm not mistaken, its actually quite similar to apps script which I've also used in the past but limited in that you cant make formulas with it for example, only scripts to run on the sheets, I have one that creates a graph and formats it the way I need to 90% of the time with a trendline and all, saved me hours already but yeah python gonna be awesome, can't wait :)

As a Python dev who uses excel regularly, this is Excel-lent news!

Title just about gave me a heart attack... thought we had another Oracle/Sun moment. But hey, that engagement hittin good

@ty.davis3

11 ай бұрын

It means they know which ones they should crack open first

The environment thing is extremely important. Its what makes it work.

I love these!!

I would have never thought that MS would make me interested in Office ever again.

@lawrencedoliveiro9104

11 ай бұрын

I still think that.

For those wondering : the third option is Extinguish. Embrace, Extend, Extinguish. EEE.

This is actually amazing

That's ought to be the most ambitious crossover ever

Excel has Javascript support also. It is called Office Script.

@Caellyan

11 ай бұрын

And has cool features like all declarations secretly being globals for developer convenience.

@mayankhb

11 ай бұрын

@@Caellyan I believe we shouldn't blame the tool if we don't know where to use it and where not to use it. I started my career with Excel, after few years, I realised that it can't handle some of my increased work load so I shifted that work to Python. It's not really hard to understand where to use a tool if you know its strengths and limitations.

@lawrencedoliveiro9104

11 ай бұрын

Remember, Microsoft is not going to offer you Python-in-Excel for free.

@adamestrada7610

11 ай бұрын

@@lawrencedoliveiro9104 lol they don't even offer Excel for free. And I highly doubt that unless you are on an enterprise plan, those cloud-based calls to a Python runtime are going to be throttled hard.

@scottydog9997

11 ай бұрын

not as good as macros though, the implementation is crap. E.g I cant access the file system to copy data from multiple spreadsheets, and create an automated data feed from hundreds of spreadsheets into one.

I litterally used python in libreoffice 2 days ago and thought: "It's so cool! Why doesn't Microsoft have this feature?" Honestly python is so good for handling data imagine having to use the basic language

@ajarivas72

11 ай бұрын

Why don’t you the Python code through a VBA macro and then import the results to Excel?

@scottydog9997

11 ай бұрын

@@ajarivas72 vba macros are getting switched off all over the place recently because of the security risks associated with them. I love VBA, but yeah you can destroy someones computer with a macro.

0:35 Guido Van Rossum, which is totally awesome. What a rhyming!

This will likely help the job market!

Quadratic looks very good, haven't tried yet though... Quadratic is a web-based spreadsheet application that runs in the browser and as a native app (via Electron) [2]. It is an infinite canvas spreadsheet with built-in Python, SQL, and Formulas[1][5]. Quadratic is designed to enable users to pull data from its source (SaaS, Database, CSV, API, etc) and then work with that data using the most popular data science tools today (Python, Pandas, SQL, JS, Excel Formulas, etc) [2]. Quadratic has several features that make it unique, including: - Multi-line formulas: In Quadratic, you can expand your formulas to as many lines as you need[1]. - Python library support: Quadratic has Python library support built-in, allowing users to bring the latest open-source tools directly to their spreadsheet[1]. - Powerful AI integration: With GPT 4.0 powered autocomplete for data, formulas, and code, users have a powerful spreadsheet companion[1]. - Infinite canvas: Unlike other spreadsheets, Quadratic has an infinite canvas (like Figma), allowing users to pinch and zoom to navigate large data sets, and everything renders smoothly at 60fps[3]. Here's a summary of some of the key features of Quadratic: - Infinite data grid with Python, JavaScript, and SQL built-in[2]. - Data connectors to pull in data from various sources[2]. - Multi-line formulas and Python library support[1]. - Powerful AI integration with GPT 4.0 powered autocomplete[1]. - Infinite canvas for easy navigation of large data sets[3]. Quadratic is available for download from its website[1], as well as from GitHub[2] and the App Store[6]. Citations: [1] www.quadratichq.com [2] github.com/quadratichq/quadratic [3] news.ycombinator.com/item?id=35456509 [4] sourceforge.net/projects/quadratic.mirror/ [5] www.producthunt.com/products/quadratic [6] apps.apple.com/us/app/quadratic-master/id351899924

@MarcCastellsBallesta

11 ай бұрын

At first I thought you were copy pasting Wikipedia. But then... 👏🏻👏🏻👏🏻

@priapulida

11 ай бұрын

@@MarcCastellsBallesta perplexityAI

@HUEHUEUHEPony

11 ай бұрын

Doesn't support JavaScript so it's kinda cringe

@priapulida

11 ай бұрын

@@HUEHUEUHEPony yeah but coming soon

I was excited until I heard about the cloud thing... Edit: But great video as always! ❤

This is actually really cool

I don't understand most of this stuff, but I still love your videos.

Grist is an open source alternative to excel that is also collaborative, and it has python support in the formulas :)

@priapulida

11 ай бұрын

also.. Quadratic is a web-based spreadsheet application that runs in the browser and as a native app (via Electron) [2]. It is an infinite canvas spreadsheet with built-in Python, SQL, and Formulas[1][5]. Quadratic is designed to enable users to pull data from its source (SaaS, Database, CSV, API, etc) and then work with that data using the most popular data science tools today (Python, Pandas, SQL, JS, Excel Formulas, etc) [2]. Quadratic has several features that make it unique, including: - Multi-line formulas: In Quadratic, you can expand your formulas to as many lines as you need[1]. - Python library support: Quadratic has Python library support built-in, allowing users to bring the latest open-source tools directly to their spreadsheet[1]. - Powerful AI integration: With GPT 4.0 powered autocomplete for data, formulas, and code, users have a powerful spreadsheet companion[1]. - Infinite canvas: Unlike other spreadsheets, Quadratic has an infinite canvas (like Figma), allowing users to pinch and zoom to navigate large data sets, and everything renders smoothly at 60fps[3]. Here's a summary of some of the key features of Quadratic: - Infinite data grid with Python, JavaScript, and SQL built-in[2]. - Data connectors to pull in data from various sources[2]. - Multi-line formulas and Python library support[1]. - Powerful AI integration with GPT 4.0 powered autocomplete[1]. - Infinite canvas for easy navigation of large data sets[3]. Quadratic is available for download from its website[1], as well as from GitHub[2] and the App Store[6]. Citations: [1] www.quadratichq.com [2] github.com/quadratichq/quadratic [3] news.ycombinator.com/item?id=35456509 [4] sourceforge.net/projects/quadratic.mirror/ [5] www.producthunt.com/products/quadratic [6] apps.apple.com/us/app/quadratic-master/id351899924

@priapulida

11 ай бұрын

Grist and Quadratic are both web-based spreadsheet applications that offer unique features. Here are some key differences between the two: Grist: - Offers a unique "visual data modeling" approach that allows users to create custom views of their data[1]. - Has a powerful formula editor that supports advanced functions like array formulas and nested functions[1]. - Offers a wide range of templates for different use cases, such as project management, inventory tracking, and budgeting[1]. - Has a user-friendly interface that makes it easy to get started with[1]. Quadratic: - Offers built-in Python, SQL, and JavaScript support, as well as powerful AI integration with GPT 4.0 powered autocomplete[1]. - Has an infinite canvas that allows users to navigate large data sets with ease. - Offers data connectors to pull in data from various sources. - Has multi-line formulas and Python library support[1]. In terms of alternatives, both Grist and Quadratic have competitors such as Google Sheets, Microsoft Excel, and other spreadsheet applications[1]. However, each of these applications offers unique features that set them apart from one another. Ultimately, the choice between Grist and Quadratic (or any other spreadsheet application) will depend on the specific needs and preferences of the user. Citations: [1] stackshare.io/getgrist/alternatives

They gave us python in excel before native python support in Windows.

@curious_banda

11 ай бұрын

Azure runs Linux, don't be surprised.

@lawrencedoliveiro9104

11 ай бұрын

They know where the revenue opportunity lies. And that is with -Office- 365, not Windows.

This seems extremely cool

The third step is Extinguish XD. Great refrence!

maleware developers gonna love this

I hope it works on the Android version! (yes my workouts are so needlessly complex I need Python in Excel at the gym)

TFW the two top data nerd tools combine forces 😮‍💨🙌🏼

0:35 that was a good rhyme.

I cannot stress to you how validated I feel hearing you praise Apps Script. It’s my daily rider at work and has advanced my career in very serious ways. I’d love to hear you talk about it more tbh.

@AntonioZL

11 ай бұрын

It's very useful when you can't avoid dealing with spreadsheets, which is something that usually happens at work

@mouthwasher

11 ай бұрын

Thanks, your comment clarified for me that he said Apps Script and not AMPscript. I was like 'what'

@x55554

11 ай бұрын

Using app scripts I automated my company HR onboarding process with no costs (besides initial time on development). It takes Google form, fills a Google docs template and saves it into pdf then sends it as an email. 😀 it generated possibly thousands and thousands of documents, it's very reliable and doesn't cost anything. App Scripts ftw

@obesewan6632

11 ай бұрын

@@x55554 that's pretty interesting, i too was looking for onboarding automation idea, can you share more detail on the flow?

It goes Embrace - Extend - Excel.

@Kaizzer

11 ай бұрын

noice

That's friggin awesome.

1:52 This is probably the most I've ever learned from a meme. I'm currently using some of these, so I took a look at the rest and will def start using some more. This is brilliant :D

You can even use the graphing feature for airfoil design and stress analysis.

@TheBendixSA

11 ай бұрын

Yes and you can calculate the angle of the dangle.

@ajarivas72

11 ай бұрын

@@TheBendixSA And run FEA

This makes sense, seeing as Anaconda's speed when "solving environment" was inspired by Windows Update (and possibly Greenpeace).

@lawrencedoliveiro9104

11 ай бұрын

I don’t use Anaconda. Is that a Windows thing?

@GSBarlev

11 ай бұрын

Hence why mamba exists.

@GSBarlev

11 ай бұрын

​@@lawrencedoliveiro9104No, conda is an alternative to pip (really poetry) that is used for creating virtual environments and installing packages. Unlike venv, it's not just limited to Python libraries and can install binaries for other languages and even alternative versions of Python. The package solver was historically very slow (as opposed to pip's solver, which was historically VERY BAD) but it's gotten better lately. There's also a drop-in replacement called mamba that is super-fast.

@marioprawirosudiro7301

11 ай бұрын

​@@lawrencedoliveiro9104No, it's a python bundle.

@toddclark419

10 ай бұрын

@@lawrencedoliveiro9104no, it’s a more robust alternative to pip.

I switched to the Insider edition of Excel but the =py function is not there?

1:24. Of course. The recently deleted their delete and insert functions. For local use

What we have learned: Python is one of the best programming language for AI and is evolving day by day!

Where the hell have you been man, we thought AI have replaced you again, Fireship 2.0 😂😂

@LuisSierra42

11 ай бұрын

Spoiler: He was replaced by AI a long time ago

@Gigusx

11 ай бұрын

@@LuisSierra42 The anticipation leading to unrolling this comment did not pay off.

im so proud of microsoft right now

It is totally awesome!

Excel now has a alternative to Visual Basic, That is good news.

@randomuser5237

11 ай бұрын

That's not an alternative. VB can run locally, this has to run on cloud. Absolutely horrible idea.

@deidyomega

11 ай бұрын

You can also run C# in excel, you have been able to forever. And C# is a fine language

@adamestrada7610

11 ай бұрын

@@randomuser5237 Adding onto this, you also can't manipulate the components of Excel object tree or develop custom UI forms with Python, only data manipulation in data frames and visualization output. As much as I'd love a full replacement for VBA, that language is like a cockroach: ugly, unwelcome, and will probably survive a nuclear apocalypse.

@BakrAli10

11 ай бұрын

​@@adamestrada7610lmao, bookmark comment later

@anoniemoss3566

11 ай бұрын

Javascript would be the sensible alternative to vba if you think of the pieces that ms already has. JS is already designed to be a document manipulating language. You would just have to add more host objects to it to do what vba does. On that note, I'm not sure why people hate vb so much, but whatever.

Award-winning ending for those of us who happen to know the third step of Microsoft's typical strategy.

@BrainPermaDeD

11 ай бұрын

Is it buying out Python? Or making the Python usage subscription based?

@tralphstreet

11 ай бұрын

@@BrainPermaDeD Extinguish.

@lawrencedoliveiro9104

11 ай бұрын

Remember that Microsoft is doing this because it has to, not out of the goodness of its heart. The only reason it has to pay attention to Python is because it is dominating the professional-quality data-analytics industry, and leaving the noddy Excel jocks in the dust. This is a way to make those Excel jocks feel they are still somehow relevant, and also pay Microsoft for the privilege.

Python OpenPyxl is also brilliant working with excel. A true saviour.

In google drive you can code with apps script, a javascript clone that can interact with every type of goole drive file

My biggest takeaway from this video has been that LibreOffice supports Python.

I think this video should have mentioned that JavaScript is already supported by Excel and is to my understanding executed locally (either within the browser when using the web version or webview when using the native app). The feature (called Office Add-Ins or Office.js) has additional benefits compared to the Python announcement: - Available on Windows, Mac and Web (Python is only available on Windows thus far) - Allows you to package and deploy your code as an add-in The Python use-case really seems to be to do something in only one workbook, whereas the Office.js stuff is for implementing something you would like to distribute for people to use across workbooks.

@AttackOnTyler

11 ай бұрын

If your company allows it. My companies group policy and sharepoint auth disables it in desktop and browser. I'll be interested in seeing how they will handle the python function execution. They may black list the api call in our proxy, or it may just go unnoticed. Making my life significantly easier since they blacklist pandas because of c++ build tools requirement. They don't want people compiling code on their machines.... It is pretty cool when you have it

man this was years in the making

This video is awesome.

What if you do a loop inside a loop though ? Do Microsoft servers crash ?

If the runtime was on the host machine, I would imagine all the reverse shells from malicious python scripts.

@deidyomega

11 ай бұрын

Thats a solid point.

@batmanatkinson1188

11 ай бұрын

For that, they could have implemented a subset of Python that does not allow system commands with os, pathlib or shutil, or network functions

@nikolaospapanastasis

11 ай бұрын

@@batmanatkinson1188 That could be the case, in case the users gave up functionallity.

@HT79

11 ай бұрын

​@@batmanatkinson1188They cannot block networking modules like urllib and requests because data analysis often has remote dependencies. Instead, they would be running this inside an isolated Kubernetes cluster and set application level permissions for the running process to prevent direct communication with its container. And even if one container gets compromised, there's usually security in place to prevent access to other containers in the cluster. (Or the devs are underpaid and didn't bother putting up all this, so I'll try to get the service account tokens 😂)

“good luck convincing your boss that’s a good idea” oh the reality 😂😂😂

The fact that I had to learn the Microsoft VB Excel language just to make my own "function" like 3 weeks ago, to only find out this has happened. Gosh, I hate this year.

Not running the code locally is too ridiculous to describe. They could run it in a local container. Also VBscript can in practice do anything the user has permissions for anyway, and a warning pop-up is still good enough for VB-macros. My guess is that they want to add value for azure services, and market the ability to run python code safely as a revolutionary advance in office work.

@scottydog9997

11 ай бұрын

Problem is VB Macros are no longer allowed to run in most government departments, unless it is on a vm. Personal experience on that one. Redeveloped a whole bunch of VBA Macros for a govt dept, only for their IT dept to switch it off as a security risk without telling anyone, and then I (a third party dev) get blamed for them not working....

Did not have that on my bingo card

Oh my god the title scared me so much, I thought you were saying they bought the language and I was terrified

Can’t believe I’m finally going to have to learn how to use excel.

just write a command shell wrapper to interact with python repl in visual basic and forgo this cloud trap

@Alticroo

11 ай бұрын

has someone done this? feels like something that someone might have done

@mdsmithson

11 ай бұрын

@@Alticroo yeah ive done it before. looks something like this Public Function ShellRun(sCmd As String) As String 'Run a shell command, returning the output as a string Dim oShell As Object Set oShell = CreateObject("WScript.Shell") 'run command Dim oExec As Object Dim oOutput As Object Set oExec = oShell.Exec(sCmd) Set oOutput = o Exec.StdOut 'handle the results as they are written to and read from the StdOut object Dim s As String Dim sLine As String While Not oOutput.AtEndOfStream sLine = oOutput.ReadLine If sLine "" Then s = s & sLine & vbCrLf Wend ShellRun = s End Function

@lawrencedoliveiro9104

11 ай бұрын

Or try a Jupyter notebook. Each cell can have any number of lines of code, and produce any number of items of associated rich output-graphics, charts, sound, video, mathematical formulas, even arbitrary HTML. And interactive widgets to let the user control that cell output. You can intersperse code cells with narrative text cells, so the notebook becomes self-documenting. And you can use languages besides Python, if you want. Where is there a spreadsheet that comes close?

@mdsmithson

11 ай бұрын

@@lawrencedoliveiro9104 yeah jupyternotebook is awesome and useful but thats beyond the scope of this context. we are talking about using excel because excel rocks. jupyternotebook is not better than excel, its useful but not as practical for the average user.

@Alticroo

11 ай бұрын

@@lawrencedoliveiro9104 I think both of these options miss the point - which is to have a complete spreadsheet + code environment in one package. Python isn't part of Excel, hence developing a project in both Excel and Python requires that any other contributors have both installed; which isn't always feasible. Being able to tap into python through Excel with just your regular run off the mill corporate Office package is a big deal for a variety of industries; both approaches seem to come from a developer or data scientist / engineer POV where the having Python is basically a guarantee

So you're saying we won't hear from analysts for about 6 months and then we will be flooded with broken python in Excel spreadsheets to replace? Thanks Microsoft!