Excel Formula Utilities for JavaScript
Excel Formula Utilities for JavaScript is a library that can be used to pretty print excel formulas or convert excel formulas into JavaScript. The JavaScript generated by this library will not execute on it's own. You'll need to include something like formula.js to cover all the functions from Excel.
##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)