excel-formula-tokenizer

Tokenize Excel formulas.

Usage no npm install needed!

<script type="module">
  import excelFormulaTokenizer from 'https://cdn.skypack.dev/excel-formula-tokenizer';
</script>

README

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'

License

MIT