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.” by ourselves and 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 returns as “Welcome to Aspose.Cells.”. As you can see in a code that we have not written our custom function anywhere in a worksheet and 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