Skip to main content

No project description provided

Project description


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


Create a Parser

import hotxlfp

p = hotxlfp.Parser()

Parse excel formulas

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}

Custom functions

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

Installing Dependencies

Depends on ply and python-dateutil.

To install dependencies automatically using pip run:

pip install -r requirements.txt


python test


coverage run --source hotxlfp test


Inside the project directory run:

python -m "scripts.update_supported_formulas"

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for hotxlfp, version 0.0.6
Filename, size File type Python version Upload date Hashes
Filename, size hotxlfp-0.0.6.tar.gz (28.5 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page