ExceLint
Finds formula errors in spreadsheets (plugin for Microsoft Excel) (by ExceLint)
formulas
Excel formulas interpreter in Python. (by vinci1it2000)
| ExceLint | formulas | |
|---|---|---|
| 2 | 2 | |
| 67 | 327 | |
| - | - | |
| 0.0 | 6.7 | |
| over 4 years ago | 29 days ago | |
| F# | Python | |
| GNU General Public License v3.0 or later | European Union Public License 1.1 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ExceLint
Posts with mentions or reviews of ExceLint.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-05.
-
Array Languages vs. the Curse of the Spreadsheet
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.
-
We are the Microsoft Excel product team. We build cool stuff like XLOOKUP, Sheet Views, and lambda in Excel. AMA!
With that in mind, has there been any talk of integrating something like ExcelLint as part of the core Excel product to help identify these errors and encourage a set or best practices amongst users?
formulas
Posts with mentions or reviews of formulas.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-05.
-
Array Languages vs. the Curse of the Spreadsheet
https://github.com/vinci1it2000/formulas
-
Efficient and Compact Spreadsheet Formula Graphs
Looking through my history, I found that I have asked this question before and got an answer: https://news.ycombinator.com/item?id=19645440
=> https://github.com/vinci1it2000/formulas
This looks really well developed now!
What are some alternatives?
When comparing ExceLint and formulas you can also consider the following projects:
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
xlcalculator - xlcalculator converts MS Excel formulas to Python and evaluates them.