@modelmap/excel-formula-tokenizer
v2.3.2 excel formula parse tokenize
excel-formula-tokenizer
Tokenize Excel formulas.
This is E. W. Bachtal's excel formula tokenizer from http://ewbi.blogs.com/develops/2004/12/excel_formula_p.html
Install
npm install excel-formula-tokenizer -S
or
yarn add excel-formula-tokenizer
Usage
const {tokenize} = require('excel-formula-tokenizer');
const tokens = tokenize('SUM(1, 2)');
tokens.forEach({value, type, subtype} => {
console.log(`value: ${value}`);
console.log(`type: ${type}`);
console.log(`subtype: ${subtype}`);
console.log();
});
API
tokenize(formula, options)
- formula - string, excel formula
- options - optional object
- options.language - Language that the formula is in:
'en-US'
or'de-DE'
- options.language - Language that the formula is in:
License
MIT
npm i @modelmap/excel-formula-tokenizer
Metadata
- MIT
- Whatever
- Atsushi Nagase
- released 1/9/2021