Apply Formula Parser

Release 2.4.0 and above.

Applying Formula Parser enables the use of Excel functions in tables.

  • If the formula-parser script is not added to the html, the Excel function input field is not displayed.
  • If the formula-parser script is not added to the html, Excel document functions cannot be used on import.

How to Apply

Use formula-parser.min.js included in externals/formulaParser.

<script type="text/javascript" src="../externals/formulaParser/formula-parser.min.js"></script>

To use Excel functions, simply enter = in a specific cell as shown below.

Formula parser example