F(x) parser

Library provides a Parser class that evaluates excel and mathematical formulas.

1. Installation
2. Implementation
1. Html
2. js
3. Features
4. API

$3

``sh
$ npm install fxparser --save
`

$3

$3

`html

var parser = new fxParser.Parser();

parser.parse('SUM(1, 3, 9)');

// It returns Object {error: null, result: 13}

`


$3

`js

var FxParser = require('fxparser').Parser;

var parser = new FxParser();

parser.parse('SUM(1, 3, 9)');

// It returns Object {error: null, result: 13}

`

$3

It supports:

* Any numbers, negative and positive as float or integer;
Arithmetic operations like +, -, /, , %, ^;
* Logical operations like AND(), OR(), NOT(), XOR();
* Comparison operations like =, >, >=, <, <=, <>;
* All JavaScript Math constants like PI(), E(), LN10(), LN2(), LOG10E(), LOG2E(), SQRT1_2(), SQRT2();
* String operations like & (concatenation eq. parser.parse('-(2&5)'); will return -25);
* Relative and absolute cell coordinates like A1, $A1, A$1, $A$1;
* Build-in variables like TRUE, FALSE, NULL
* Custom variables;
* Custom functions/formulas;
* Node and Browser environment.

$3

`sh
$ node runthistest.js
``