[srazzaque]

Yep, I've long conjectured that Excel is what sells MS office. Every other product in the Office suite, including PowerPoint, has very viable alternatives.

Excel has a 100% a strong-hold in most finance departments. I've worked with many finance professionals who's very first instinct for any type of work is to open Excel. When interacting with any data outside of Excel, they'll demand a way to get it into Excel.

[bsder]

Excel rules the roost because it is the GUI to manipulate tabular data.

To be honest: Is there an alternative?

I've been looking for a spreadsheet so that I can "drive spreadsheet from Python" rather than the usual "drive Python from spreadsheet".

As far as I can tell, that doesn't exist.

There are read-only variants to analyzed tabular data, but there seem to be none that allow me to do lots of editing in a visual way.

[msteffen]

It’s JS rather than Python, but Google Apps Script is quite useful for this, IME.

I once wrote a small app to add up all shared expenses among a group of roommates and calculate how much each owed the others. It pulled together rent (recurring), various utilities (from my gmail) and one-off shared expenses (e.g. toilet paper) from a Google form/spreadsheet, added in any money owed from the prior month and generated a nice report, in what ended up being 100-200 lines of code after a few years of living together.

[paradox460]

Isn't officescript much the same thing?

[fifilura]

We successuflly transitioned our finance team from excel to google sheets.

The killer feature was their APIs, where microsoft still sucks.

We could show them that if you put the data in sheets we could mount it from bigquery and process it from there. Or load it from a notebook.

This created a good-enough hybrid solution where spreadsheets could interact with code.

[srazzaque]

To be clear: I'm not bashing Excel. Agree that there isn't a viable alternative for explorative table manipulation, and the experience of "think/change/see-results" is second to none. I myself use it for low-stakes tasks such as personal budgeting and quick analysis to validate my assumptions on tabular data.

Key word there is low-stakes. I think Excel gets a lot of heat because it's often found used in contexts where it's wholly inappropriate to use (eg driving critical production decisions from SalesAnalysis_JimVersion_v1.8_FINAL.xlsx). That's not really Excel's fault.

[canucker2016]

They just announced this, but it runs python in an azure container - not sure how it hooks into excel unless excel is also running in the cloud, but a lot of people would want to run it locally instead.

See https://techcommunity.microsoft.com/t5/microsoft-365-blog/in...

[bradrn]

> I've been looking for a spreadsheet so that I can "drive spreadsheet from Python" rather than the usual "drive Python from spreadsheet".

You might find Mito [https://www.trymito.io/] interesting. I haven’t really used it myself, but it sounds like what you’re looking for.

[qubex]

I’m a very happy (and I believe competent) Apple Numbers user. The only thing I miss from Excel is recursive evaluation (which is necessary for evaluating certain financial models).