7 Tools for better Excel into Javascript Formula conversion ( 72 )

 

 

Sometimes you have to deal with these things, to convert some Excel Formula in other programming language. It can be php, javascript, C++ or whatever. Most of topics are answered on stackoverflow.com as usual but searching on web, brings you also links to some tools that help on this process.

Curious thing is that, these Converters/Beautifiers are not able to transform Base to Exponent Power, which has to be like:



# Excel formula example: =ROUND((P12/100+1)^(1/P13)-1);6
// Here ;6 means Numerical Precision 6.
// Same formula in Javascript: =Math.round( (Math.pow(1 + (P12/100), 1/P13) - 1) * 100000) /100000;
// Same formula in PHP: =(round(pow(1 + (P12/100), 1/P13) - 1) * 100000) /100000;


The list bellow contains some of these as Beautifiers, Parsers or Analysers
Excel Formula Beautifier http://excelformulabeautifier.com/ https://github.com/joshatjben/excelFormulaUtilitiesJS
JavaScript parser generator http://zaach.github.io/jison/demos/calc/ http://zaach.github.io/jison/ https://github.com/zaach/jison
Formula.js - JavaScript implementation of most formula functions supported by Microsoft Excel 2013 and Google Spreadsheets http://stoic.com/formula/
Excel Formula Parsing http://ewbi.blogs.com/develops/2004/12/excel_formula_p.html
Calx calculate the value based on given formula, just like Excel does. http://www.xsanisty.com/calx/formula/ https://github.com/zaach/jison
Handsontable 0.9.16 a minimalistic Excel-like data grid editor for HTML, JavaScript & jQuery http://handsontable.com/ https://github.com/warpech/jquery-handsontable
PHPExcel A pure PHP library for reading and writing spreadsheet files https://github.com/PHPOffice/PHPExcel