Live data from Hacker News

Microsoft is bringing Python to Excel

theverge.com

251–260 of 455 posts

Re: Microsoft is bringing Python to Excel

#251
Many comments are criticizing the fact that this only runs in the cloud. And if Microsoft instead announced this would only run locally, they would instead be deploring the massive remote code execution vulnerabilities that this opens.

For this feature, there's no question that providing it in the cloud is much, much better for security. Microsoft can now execute the Python code in Firecracker VMs which provide much better sandboxing than your local PC could.

Re: Microsoft is bringing Python to Excel

#252
It's interesting how aggresively enthusiastic HN are about Excel when it comes to discussions about Excel vs. open-source alternatives. Any mention of alternatives are quickly and aggresively shot down, ocassionally to the point of personal attacks (if you're satisfied with LibreOffice you don't have real job, etc.).

On the meanwhile, just a few threads ago there was a (quite fair) browser benchmark where Chrome comes up on top on almost every test. People in the comments instantly rushes in proclaiming how proud they are for using Firefox even if it is technically inferior, solely because it is not owned by Google.

What's up with this divide? Firefox user, btw.

Re: Microsoft is bringing Python to Excel

#254
post #249

This was a nice surprise to see today as an Ex-Excel developer who worked on trying to bring Python to Excel (and, I guess, failing ;)). 7+ years ago I had the option of leaving the Excel team. My then boss’s boss knew I had an interest in bringing Python to Excel and offered me a chance to tackle it if I chose to stay. What was meant to be a 6 month project turned into a ~3 year project, the Python part faded away a…

Thanks for your work! The async JS functions are amazing and allowed me to ship rock-solid Custom functions with xlwings and Python. The problem with Office.js is that it’s just simply too hard to get started with all the npm bloat for the average Excel user (even more professional devs struggle). Well, I am pretty happy how I am saving users from having to use Node.js: https://docs.xlwings.org/en/latest/pro/server/officejs_custo...

Re: Microsoft is bringing Python to Excel

#255
post #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 o…

You're probably asking for something impossible. It's common for the raw data to not fit in excel. You have to do some sort of aggregation or filtering, which means having that app where you aggregate and filter.

Almost all these tools support exporting to Excel or CSV, so they can do whatever they want in Excel after that.

Re: Microsoft is bringing Python to Excel

#256

Earlier quoted context omitted.

> This means that the process is eternally tied to the cloud now. "You will own nothing, and you will be happy" has followed us to... spreadsheets? We can't even own the things we're wageslaving away at our desk for.

> We can't even own the things we're wageslaving away at our desk for. But we never owned those things we're wageslaving away at our desk for, that's why its called wageslaving. Whether our employers own them or rent them seems pretty immaterial.

Yeah I didn't phrase it well. My point was even our work is becoming intangible now "for the greater good." Just funny to see the progression of things.

Re: Microsoft is bringing Python to Excel

#257
post #204

Earlier quoted context omitted.

Excel makes a total mess of many kinds of imports, assuming they are dates when they are not or assuming US vs UK formats dates etc. https://www.theverge.com/2020/8/6/21355674/human-genes-renam... However, to my eyes, and probably most people, 20230822090811 does not look like a "date string", it's a number. It's correct to display it as scientific notation if it's too many digits to fit into the width of a cell. Ple…

Are you saying that excel does preserve digits? I must be doing something very wrong (entirely possible), cause once the document is saved, the digits are gone.

That reads as a normative "should" to me. It doesn't preserve digits, but it ought to.

Re: Microsoft is bringing Python to Excel

#258
post #49

Earlier quoted context omitted.

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.

>> Hi I work on Excel, can you write a summary of why that's important to you and send it to How out of touch with the real world is the Excel team?

A hacker news comment chain isn’t a great place to follow up on feedback. Email’s alright! I don’t think that’s too out of touch.

Re: Microsoft is bringing Python to Excel

#259

It's interesting how aggresively enthusiastic HN are about Excel when it comes to discussions about Excel vs. open-source alternatives. Any mention of alternatives are quickly and aggresively shot down, ocassionally to the point of personal attacks (if you're satisfied with LibreOffice you don't have real job, etc.). On the meanwhile, just a few threads ago there was a (quite fair) browser benchmark where Chrome come…

I think it comes from users being deceived by the product UX. My impression is that using Firefox, I often don’t miss other browsers. Using Libre Office makes me miss Excel, Keynote et al. I can’t pinpoint it to a single thing, it just feels dated and inferior. Open source in general seems to work better for infrastructure than applications, even if I have my own favorites. It partly has to do with the lack of product teams like designers, but also that an app is a single endpoint that makes a hard business to sell multiple flavors.

Re: Microsoft is bringing Python to Excel

#260
post #165

Earlier quoted context omitted.

True, but financial calculations tend to involve non-integral numbers. Python has arbitrary-precision decimals via: https://docs.python.org/3.11/library/decimal.html

Financial calculations are also sometimes already used to doing math in integral pennies (or eighths of a penny) for performance/storage reasons. That works just fine with one BigInt. Or you can build arbitrary-precision rationals from just two BigInts. (There are some JS libraries out there already for that.)

"You can build arbitrary-precision rationals" is a far cry from saying, "this is a language designed for precision arithmetic." You can technically build arbitrary-precision rationals without BigInts using arrays, but it's not exactly ergonomic.

Even if we stipulate that users will be cognizant of floating point limitations and convert everything to integers, JS still requires all literals to be suffixed with n to avoid silently losing precision when integral values exceed 2*52.

Post reply on HN