CellSetArrayFormula Method (String, Int32, Int32, FormulaParseOptions, Object)

Sets an array formula to a range of cells.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 21.7.0.0 (21.7)
Syntax
public void SetArrayFormula(
	string arrayFormula,
	int rowNumber,
	int columnNumber,
	FormulaParseOptions options,
	Object[][] values
)

Parameters

arrayFormula
Type: SystemString
Array formula.
rowNumber
Type: SystemInt32
Number of rows to populate result of the array formula.
columnNumber
Type: SystemInt32
Number of columns to populate result of the array formula.
options
Type: Aspose.CellsFormulaParseOptions
Options for parsing the formula.
values
Type: SystemObject
values for those cells with given array formula
See Also