formulas: An Excel formulas interpreter in Python.

Latest Version in PyPI Build status Code coverage Documentation status Dependencies up-to-date? Issues count Supported Python versions Project License Live Demo

release

1.2.4

date

2022-07-02 17:45:00

repository

https://github.com/vinci1it2000/formulas

pypi-repo

https://pypi.org/project/formulas/

docs

http://formulas.readthedocs.io/

wiki

https://github.com/vinci1it2000/formulas/wiki/

download

http://github.com/vinci1it2000/formulas/releases/

donate

https://donorbox.org/formulas

keywords

excel, formulas, interpreter, compiler, dispatch

developers
license

EUPL 1.1+

What is formulas?

formulas implements an interpreter for Excel formulas, which parses and compile Excel formulas expressions.

Moreover, it compiles Excel workbooks to python and executes without using the Excel COM server. Hence, Excel is not needed.

Installation

To install it use (with root privileges):

$ pip install formulas

Or download the last git version and use (with root privileges):

$ python setup.py install

Install extras

Some additional functionality is enabled installing the following extras:

  • excel: enables to compile Excel workbooks to python and execute using: ExcelModel.

  • plot: enables to plot the formula ast and the Excel model.

To install formulas and all extras, do:

$ pip install formulas[all]

Development version

To help with the testing and the development of formulas, you can install the development version:

$ pip install https://github.com/vinci1it2000/formulas/archive/dev.zip

Table of Contents

Indices and tables