Does the Application.Evaluate method exist in excel js api? I'd like to run custom functions from the script and get its value. The original method is descsribed here https://docs.microsoft.com/en-us/office/vba/api/excel.application.evaluate
1 Answers
Sorry, evaluate API is currently not supported so far Excel JS API. I would suggest that you could submit your request on uservoice, and upvote your request. Thanks.
A possible workaround You may try: to put the formula that you would like to evaluate into the cell and leverage the Excel calculation engine to get the evaluation result then you could get the value by range.values from this cell.
Related