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
Grab the latest js files in the dist folder.
<script src="excel-formula.js" />
<script>
var formattedFormula = excelFormulaUtilities.formatFormulaHTML('IF(1+1=2,"true","false")');
alert(formattedFormula)
</script> var formula = require('excel-formula');
var formattedFormula = formula.formatFormula('IF(1+1=2,"true","false")');
console.log(formatFormula);See basic usage above.
formula.getTokens (formula);
formula.formatFormula (formula, [opts])
formula.toJavaScript(formula)
formula.toCSharp(formula)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)
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent