Spread Windows Forms 17
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffRead Interface / ExcelSetCellFormula Method / ExcelSetCellFormula(Int16,Int32,Int32,BinaryReader,BinaryReader,Int32,Int32) Method
Sheet index
Row index
Column index
Binary reader
Extra binary reader
Index of first row
Index of first column


In This Topic
    ExcelSetCellFormula(Int16,Int32,Int32,BinaryReader,BinaryReader,Int32,Int32) Method
    In This Topic
    FORMULA - Excel Biff Record Sets the formula for the specified location and options.
    Syntax
    'Declaration
     
    
    Overloads Function ExcelSetCellFormula( _
       ByVal sheet As Short, _
       ByVal row As Integer, _
       ByVal col As Integer, _
       ByVal rdr As BinaryReader, _
       ByVal rdrExtra As BinaryReader, _
       ByVal rowFirst As Integer, _
       ByVal colFirst As Integer _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelBiffRead
    Dim sheet As Short
    Dim row As Integer
    Dim col As Integer
    Dim rdr As BinaryReader
    Dim rdrExtra As BinaryReader
    Dim rowFirst As Integer
    Dim colFirst As Integer
    Dim value As Boolean
     
    value = instance.ExcelSetCellFormula(sheet, row, col, rdr, rdrExtra, rowFirst, colFirst)

    Parameters

    sheet
    Sheet index
    row
    Row index
    col
    Column index
    rdr
    Binary reader
    rdrExtra
    Extra binary reader
    rowFirst
    Index of first row
    colFirst
    Index of first column
    See Also