Direct calculation of custom function without writing it in a worksheet

This article explains how you can directly calculate your custom functions without first writing them in a worksheet. Please use the Worksheet.calculateFormula(string formula, CalculationOptions opts) method for this purpose.

Direct calculation of custom function without writing it in a worksheet

Please see the following sample code that illustrates the usage of this method. We have used a custom function named MyCompany.CustomFunction() and we calculate its value as “Aspose.Cells.” ourself; then this value is automatically concatenated with the value of cell A1, which is “Welcome to “, by the calculation engine, and the final calculated value is “Welcome to Aspose.Cells.”. As you can see in the code, we have not written our custom function anywhere in a worksheet; it is calculated directly by our own custom logic.

Console Output

Below is the console output of the above sample code.

 Calculated Value: Welcome to Aspose.Cells.

Related Article

• Implement Custom Calculation Engine to extend the Default Calculation Engine of Aspose.Cells