GrapeCity.Documents.Excel.IRange.FormulaArray

FormulaArray Property

Gets or sets the array formula of a range.

string FormulaArray { get; set; }

Property FormulaArray As String

IRange range = worksheet.Range["A1:A3"];
range.FormulaArray = "=ROW(A1:A3)";
workbook.Calculate();
object value = worksheet.Range["A1"].Value;