hotxlfp intends to be a python version of the javascript handsontable excel formula parser differences are acceptable to make it more pythonic or the function implementations more correct.

You can install using pip

pip install hotxlfp

import hotxlfp
p = hotxlfp.Parser()

p.parse('SUM(1,2,3)') # returns {'result': 6, 'error': None}

It's also fine to use semi-colons as separators (they're used by excel depending on your locale)

p.parse('SUM(1;2;3)') # returns {'result': 6, 'error': None}

Say you have a function called triple:

def triple(x):
    return x*3

You can teach the parser to use it with set_function

p.set_function('TRIPLE', triple)
p.parse('TRIPLE(2)') # returns {'result': 6, 'error': None}

You can also set variables that you can then use in your formulas

p.set_variable('foo', 33)
p.parse('foo/3') # returns {'result': 11.0, 'error': None}

Fork the project

Depends on ply and python-dateutil.

To install dependencies automatically using pip run:

pip install -r requirements.txt

python setup.py test

coverage run --source hotxlfp setup.py test

Inside the project directory run:

python -m "scripts.update_supported_formulas"