Returning a Range of Values using ICustomFunction

The ICustomFunction is deprecated since the release of Aspose.Cells for Java 20.8. Please use the AbstractCalculationEngine class. The use of the AbstractCalculationEngine class is described in the following article.

Returning a Range of Values using AbstractCalculationEngine.

Aspose.Cells provides the ICustomFunction interface, which is used to implement user‑defined or custom functions that are not supported by Microsoft Excel as built‑in functions.

In most cases, when you implement the ICustomFunction interface method, you need to return a single cell value. However, sometimes you need to return a range of values. This article explains how to return a range of values from ICustomFunction.

The following code implements ICustomFunction and returns the range of values via its method.

Create a class with a function CalculateCustomFunction. This class implements ICustomFunction.

Now use the above function in your program