Live data from Hacker News

Microsoft is bringing Python to Excel

theverge.com

51–60 of 455 posts

Re: Microsoft is bringing Python to Excel

#51
post #3

》Python calculations run in Microsoft’s Cloud No thanks!

That caught my attention too! I'm curious why they would choose this model.

Looking at all the packages available, I'm sure that's why. You make it a much simpler thing to just develop that runtime for a known environment that you control vs a browser/local that requires a lot more engineering effort to make sure it works correctly for everyone.

Re: Microsoft is bringing Python to Excel

#53
post #3

》Python calculations run in Microsoft’s Cloud No thanks!

That caught my attention too! I'm curious why they would choose this model.

My guess is that it makes it easier to work on large files which is common without downloading the whole file and it makes CoPilot related efforts much easier.

I work on Excel but not this feature and am happy to ask around if people are interested.

Re: Microsoft is bringing Python to Excel

#54

Earlier quoted context omitted.

That caught my attention too! I'm curious why they would choose this model.

Looking at all the packages available, I'm sure that's why. You make it a much simpler thing to just develop that runtime for a known environment that you control vs a browser/local that requires a lot more engineering effort to make sure it works correctly for everyone.

You could ship that known environment as an optional download.

Re: Microsoft is bringing Python to Excel

#56
post #49

I wish it wasn't solely powered only by Microsoft Cloud and could support python running locally, but regardless I think this will still be huge and single-handedly modernizes Excel by a large margin. This alone could eliminate the need for websites that just want this sort of data. I can think of a past project at a previous job I did building an analytics website used only by a handful of people internally that cou…

Hi I work on Excel, can you write a summary of why that's important to you and send it to bgruenbaum@microsoft.com ? I'll get it in front of a PM. Alternatively PMs read all the feedback sent via the feedback UI on Excel web and desktop so you can use that instead if you prefer.

It won't work offline, for one. I use Office exclusively without internet as otherwise who knows what private stuff it's sending back to Microsoft, which then becomes eligible for warrantless surveillance by the federal police.

I know it's old fashioned to want local software to only change things on my local file system, but if I didn't want that paradigm, I'd just use Google Docs.

Re: Microsoft is bringing Python to Excel

#57

I wish it wasn't solely powered only by Microsoft Cloud and could support python running locally, but regardless I think this will still be huge and single-handedly modernizes Excel by a large margin. This alone could eliminate the need for websites that just want this sort of data. I can think of a past project at a previous job I did building an analytics website used only by a handful of people internally that cou…

> This alone could eliminate the need for websites that just want this sort of data

I catch flak for this all the time! Our users just want to be able to use Excel to free-form analyze their data. IT, of which I'm a part of, insists on building web apps to do that for them. They're never happy because all they wanted was Excel.

I keep explaining all we have to do is build a data mart built using SQL Server, and use our ETL tools to keep it populated with the data they need to analyze. Don't let them anywhere near the source data. They keep looking at me like I have ten heads. Instead they want to launch multi-million dollar projects to bring Tableau to our users - and they don't want it! It's asinine!

Re: Microsoft is bringing Python to Excel

#58
post #46

I wish it wasn't solely powered only by Microsoft Cloud and could support python running locally, but regardless I think this will still be huge and single-handedly modernizes Excel by a large margin. This alone could eliminate the need for websites that just want this sort of data. I can think of a past project at a previous job I did building an analytics website used only by a handful of people internally that cou…

It sort of makes sense to limit it to the cloud, because making Python an integral part of the Excel file format would reduce its portability and introduce all sorts of compatibility headaches going forward.

Excel already has versioned file formats with significantly different affordances, and hasn't appeared to have all sorts of compatibility headaches as a result.

Re: Microsoft is bringing Python to Excel

#59
post #53

Earlier quoted context omitted.

That caught my attention too! I'm curious why they would choose this model.

My guess is that it makes it easier to work on large files which is common without downloading the whole file and it makes CoPilot related efforts much easier. I work on Excel but not this feature and am happy to ask around if people are interested.

The last thing in the universe I'm interested when editing Excel is making CoPilot related efforts any easier.

Re: Microsoft is bringing Python to Excel

#60
post #25

Off topic but why can’t we all go back to office 97? It basically does all the same stuff and it would be lightning fast on modern machines. You don’t even need internet to use it.

Thank you. Yes, I could get ELT to accept a “RAD” Access app built and shipped during the time it takes to pitch to choose just the CRUD library or JS Framework alone.
Post reply on HN