Spread WPF 17
GrapeCity.Excel Namespace / IExcelReader Interface / SetArrayFormula Method
The zero based sheet index used to locate the IExcelWorksheet instance
The zero based inclusive top left cell row index
The zero based inclusive bottom right cell row index
The zero based inclusive top left cell column index
The zero based inclusive top left cell column index
The array formula for these cell


In This Topic
    SetArrayFormula Method (IExcelReader)
    In This Topic
    Set array formula to a range of cells
    Syntax
    'Declaration
     
    Sub SetArrayFormula( _
       ByVal sheet As Integer, _
       ByVal rowFirst As Integer, _
       ByVal rowLast As Integer, _
       ByVal columnFirst As Short, _
       ByVal columnLast As Short, _
       ByVal arrayFormula As IExcelFormula _
    ) 
    'Usage
     
    Dim instance As IExcelReader
    Dim sheet As Integer
    Dim rowFirst As Integer
    Dim rowLast As Integer
    Dim columnFirst As Short
    Dim columnLast As Short
    Dim arrayFormula As IExcelFormula
     
    instance.SetArrayFormula(sheet, rowFirst, rowLast, columnFirst, columnLast, arrayFormula)
    void SetArrayFormula( 
       int sheet,
       int rowFirst,
       int rowLast,
       short columnFirst,
       short columnLast,
       IExcelFormula arrayFormula
    )

    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
    ExceptionDescription
    throws when the formula is null or empty.
    See Also