mesh

You might be interested in mesh [1], which is sort of what you're angling at. The creator did a video explaining it [2]. [1] https://github.com/chrispsn/mesh [2] https://www.youtube.com/watch?v=CEG9pFNYBCI&t=499s

Thanks! And hopefully the README helps too: https://github.com/chrispsn/mesh/blob/master/README.md

Cool project, but the title is a bit confusing: > "A code editor that feels like a spreadsheet" It literally is a spreadsheet though right? Is there something that separates this from an google sheet? Also, the source repository on [1] Github is a bit more informative (for this audience). [1] https://github.com/chrispsn/mesh

Good point, thank you. It is added to the isssues log. I’d love to hear more about what would make Mesh more accessible for you and others. https://github.com/chrispsn/mesh/issues/68

On [1], you would probably like Mesh Spreadsheet. Spreadsheet-defined functions (via IPC), lambdas, dynamic arrays, text pane for showing and editing sheet-as-code, editing tables as a first-class data structure, all portable and free and based on JS as the formula language. https://github.com/chrispsn/mesh

It's understandable why Microsoft would be slow-moving to incorporate new languages into Excel; what is popular now could change (eg if you add Python, do you also do R?), and restricting the number of languages available means people in an office can more easily work with each other. But there has been progress! - Excel already has a native JavaScript API. [1] - They are seeking feedback on implementing Python as an Excel scripting language. [2] - It's a little esoteric / proprietary, but the language backing Excel's "Get & Transform" feature, M, is a noticeable jump in power. [3] Nevertheless, it's still surprising there hasn't been more innovation in the spreadsheet space given Excel's shortcomings. So I'm working on Mesh, a spreadsheet that feels more like a 'real' programming language (because it's just JavaScript). [4] [1] https://w

Power Query, aka Get & Transform (built into Excel 2016), is probably the best new feature since Excel Tables were introduced in v2007. It lets you pull data from local, network and web sources - including databases - with a relatively easy UI. The queries can also be refreshed. My main complaint about spreadsheets (or at least Excel) is: you can't generate data of arbitrary length via a formula and display it on the grid without manually managing the cells it takes up. An example where this would be handy is an array formula for unique items. It seems that maintaining location-based referencing as a feature (referring to data based on cell location, eg '=A1') makes this difficult to implement. Power Query allows this via List.Generate and the M language, but you need to break the spreadsheet auto-calculation paradigm to use it. This is w