koala
Transpose your Excel calculations into python for better performances and scaling. (by vallettea)
pycel
A library for compiling excel spreadsheets to python code & visualizing them as a graph (by dgorissen)
| koala | pycel | |
|---|---|---|
| 1 | 3 | |
| 139 | 551 | |
| - | - | |
| 0.0 | 0.0 | |
| almost 2 years ago | over 1 year ago | |
| Python | Python | |
| GNU General Public License v3.0 only | GNU General Public License v3.0 only |
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.
koala
Posts with mentions or reviews of koala.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-04-03.
-
access excel sheet programatically
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.
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
https://github.com/dgorissen/pycel
-
As a person with Python skills, what do you think of spreadsheet software like Excel, Airtable, etc.?
Also have a look at Pycel. It translates Excel spreadsheets into Python.
-
access excel sheet programatically
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 koala and pycel you can also consider the following projects:
xlcalculator - xlcalculator converts MS Excel formulas to Python and evaluates them.
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.