pycel vs xlcalculator

pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph (by dgorissen)

Suggest topics

Source Code

Suggest alternative

Edit details

xlcalculator

xlcalculator converts MS Excel formulas to Python and evaluates them. (by bradbase)

Suggest topics

Source Code

Suggest alternative

Edit details

InfluxDB - 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.

www.influxdata.com

featured

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

featured

pycel		xlcalculator
	Project
3	Mentions	3
551	Stars	107
-	Growth	-
0.0	Activity	4.4
over 1 year ago	Latest Commit	3 months ago
Python	Language	Python
GNU General Public License v3.0 only	License	GNU General Public License v3.0 or later

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.

pycel

Posts with mentions or reviews of pycel. 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
5 projects | news.ycombinator.com | 5 Mar 2024

https://github.com/dgorissen/pycel
As a person with Python skills, what do you think of spreadsheet software like Excel, Airtable, etc.?
1 project | /r/Python | 2 Nov 2021

Also have a look at Pycel. It translates Excel spreadsheets into Python.
access excel sheet programatically
4 projects | /r/learnpython | 3 Apr 2021

Kind of. There are a few libraries that attempt to give full Excel formula functionality in Python, but they are not complete. That is to say, they don't work on all formulae, and certain newer Excel feature (like array formulae) are unsupported. These are: pycel, koala, xlcalculator.

xlcalculator

Posts with mentions or reviews of xlcalculator. 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
5 projects | news.ycombinator.com | 5 Mar 2024
I know of some Python libraries that do something like this:
```
  https://github.com/bradbase/xlcalculator
```
Python Type Hints Are Turing Complete
9 projects | news.ycombinator.com | 9 Sep 2022

Looks like it's xlcalculator:
https://github.com/bradbase/xlcalculator#addingregistering-e...
access excel sheet programatically
4 projects | /r/learnpython | 3 Apr 2021

Kind of. There are a few libraries that attempt to give full Excel formula functionality in Python, but they are not complete. That is to say, they don't work on all formulae, and certain newer Excel feature (like array formulae) are unsupported. These are: pycel, koala, xlcalculator.

What are some alternatives?

When comparing pycel and xlcalculator you can also consider the following projects:

koala - Transpose your Excel calculations into python for better performances and scaling.

xlwings - xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.

json-parser-in-typescript-very-bad-idea-please-dont-use - JSON Parser written entirely in TypeScript's type system

json-parser-in-typescript-ver

di - Pythonic dependency injection

python-typing-machines - Python type hints are Turing complete.

pydantic - Data validation using Python type hints

formulas - Excel formulas interpreter in Python.

LaTeXML - LaTeXML: a TeX and LaTeX to XML/HTML/ePub/MathML translator.