Set array formula to a range of cells
Syntax
'Declaration
Sub SetArrayFormula( _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal columnFirst As System.Short, _
ByVal columnLast As System.Short, _
ByVal As IExcelFormula _
)
'Usage
Dim instance As IExcelReader
Dim sheet As System.Integer
Dim rowFirst As System.Integer
Dim rowLast As System.Integer
Dim columnFirst As System.Short
Dim columnLast As System.Short
Dim arrayFormula As IExcelFormula
instance.SetArrayFormula(sheet, rowFirst, rowLast, columnFirst, columnLast, arrayFormula)
void SetArrayFormula(
System.int ,
System.int ,
System.int ,
System.short columnFirst,
System.short columnLast,
IExcelFormula
)
Parameters
- sheet
- The zero based sheet index used to locate the IExcelWorksheet instance
- rowFirst
- The zero based inclusive top left cell row index
- rowLast
- The zero based inclusive bottom right cell row index
- columnFirst
- The zero based inclusive top left cell column index
- columnLast
- The zero based inclusive top left cell column index
- arrayFormula
- The array formula for these cell
Exceptions
Exception | Description |
System.ArgumentNullException | throws when the formula is null or empty. |
See Also