Array Languages vs. the Curse of the Spreadsheet

• ExceLint

  2 67 0.0 F#

  Discontinued Finds formula errors in spreadsheets (plugin for Microsoft Excel)

  

It is a proper programming language.

For #1, there has been research on linting and automated semantic error or smell detection in Excel (e.g., https://github.com/ExceLint/ExceLint). Some features are live in Excel today!

For #2, Excel now supports Python.

I don't think you need to do any conversions, all of the necessary information exists in the spreadsheet.

• xlcalculator

  3 105 4.4 Python

  xlcalculator converts MS Excel formulas to Python and evaluates them.

I know of some Python libraries that do something like this:

  https://github.com/bradbase/xlcalculator

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• pycel

  3 551 0.0 Python

  A library for compiling excel spreadsheets to python code & visualizing them as a graph

https://github.com/dgorissen/pycel

• formulas

  2 325 6.9 Python

  Excel formulas interpreter in Python.

https://github.com/vinci1it2000/formulas

• uiua

  9 1,368 10.0 Rust

  A stack-based array programming language

  

This is what I love in Uiua[1]. That operators can be written as english words instead of unicode symbols. Makes it quite similar looking to functuinal point free code.

[1]: https://www.uiua.org/

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project