search

joshbtn / excelFormulaUtilitiesJS

This library contains methods to beautify an excel formula. This library also contains functions to convert an excel formula to JavaScript (ECMAScript) or C# and python.
http://excelformulabeautifier.com/
Other
394 stars 101 forks source link

Throwing an error when an excel function is not supported #93

Open coral-re-ma opened 3 years ago

coral-re-ma commented 3 years ago

Hi, I want to use the "formula.toJavaScript(formula)" but there are some excel functions like : ISBLANK or NOT that are not supported for js ( and cSharp). So first of all it will be great if you can add it, but anyway in order to be able to use it safely, It would be nice that when an excel function is not supported, an error will be thrown instead of copying the string as it is (e.g instead of keeping the string "NOT" inside the converted formula when NOT = "!" is not configured, throwing an unsupported function error)

Thanks!

joshbtn commented 3 years ago

Check out https://formulajs.info/. This should give you a pretty complete implementation of excel formulas for JS.