formulas: An Excel formulas interpreter in Python.

Latest Version in PyPI Build status Code coverage Documentation status Issues count Supported Python versions Project License Live Demo

release:

1.2.7

date:

2023-11-15 01:00: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