Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
44 lines (37 sloc) 1.64 KB

Excel Formula Utilities for JavaScript

Build Status

ExcelFormulaBeautifier.com

To submit pull requests for ExcelFormulaBeautifier.com please oppen a pull request after gh-pages branch. To submit pull requests for ExcelFormulaBeautifier.com please use this branch. Changes to the core js library live in the master branch.

Install using npm

npm install excel-formula

Installation for web

Grab the latest js files in the dist folder.

Basic usage for web

<script src="excel-formula.js" />
<script>
    var formattedFormula = excelFormulaUtilities.formatFormulaHTML('IF(1+1=2,"true","false")');
    alert(formattedFormula)
</script>

Basic Usage for Node

var formula = require('excel-formula');
var formattedFormula = formula.formatFormula('IF(1+1=2,"true","false")');
console.log(formatFormula);

Node methods

See basic usage above.

    formula.getTokens (formula);
    formula.formatFormula (formula, [opts])
    formula.toJavaScript(formula)
    formula.toCSharp(formula)

Web methods

excelFormulaUtilities is a global variable.

    excelFormulaUtilities.getTokens (formula);
    excelFormulaUtilities.formatFormula (formula, [opts]) // This will work fine in a pre tag
    excelFormulaUtilities.formatFormulaHTML(formula) // Use this if you want the output as html.
    excelFormulaUtilities.formula2JavaScript(formula)
    excelFormulaUtilities.formula2CSharp(formula)
Jump to Line
Something went wrong with that request. Please try again.