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

Need real js calculation, not the result #37

Closed oakmedia closed 8 years ago

oakmedia commented 8 years ago

Hello,

i tried your class, but is it right, that it only calculates results. I can not see any line of Javacript Code. Could you perhaps help me?

Thanks, Regards, Olaf

joshbtn commented 8 years ago

I'm not sure I understand. Do you have an example or screenshot of how you are trying to use it?

joshbtn commented 8 years ago

Sorry, After reading this again I think I understand what you are asking. This library only deals with converting formulas to the equivalent JavaScript. It will not 'solve' or resolve the resulting values of the JavaScript formulas.

To get the results from the JavaScript formulas you will need to run the converted JavaScript paired with something like https://github.com/sutoiku/formula.js/ to make sure that all of the excel functions can be executed.

Hopefully this answers your question?

oakmedia commented 8 years ago

Hi Josh,

yes i think this will help a little bit... thank you.

Regards,

Olaf

Am 12.05.2016 um 17:54 schrieb Josh Bennett:

Sorry, After reading this again I think I understand what you are asking. This library only deals with converting formulas to the equivalent JavaScript. It will not 'solve' or resolve the resulting values of the JavaScript formulas.

To get the results from the JavaScript formulas you will need to run the converted JavaScript paired with something like https://github.com/sutoiku/formula.js/ to make sure that all of the excel functions can be executed.

Hopefully this answers your question?

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/joshbtn/excelFormulaUtilitiesJS/issues/37#issuecomment-218801550