That’s fun. CSE formulas have always felt like forbidden magic due to the unintuitive implementation and ease with which an unfamiliarity user can break them.
These look like a way more intuitive way to interact with arrays in excel.
Took me a while to realize xlwings was a separate thing which was disappointing
At my work, we've recently finished rewriting a macroeconomic model from Excel/VBA into Python. Would've been nice--and easier for the economists--if Python had simply been available in Excel. But I think the long-term advantages of teaching the econ modeling team Python plus gitand an agile-ish workflow (versus no defined structure that led to a tangled mess of VBA in the first place) will be worth it.
MS seems to push Python these days, but I doubt it will happen for Excel: they rewrote a lot of it in JS, so it makes more sense for them to provide a JS binding. Besides, making Python decently works on the Web version of Office would be a huge challenge.
9 comments
[ 3.0 ms ] story [ 27.4 ms ] threadThese look like a way more intuitive way to interact with arrays in excel.
Took me a while to realize xlwings was a separate thing which was disappointing
> Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.
"without any specific timeline" sounds very much like the distant future (if at all).
I can’t imagine it was rewritten in JS since I left.