Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffRead Interface / ExcelSetCellFormula Method / ExcelSetCellFormula(Int16,Int32,Int32,String) Method
Sheet index
Row index
Column index
Formula string


In This Topic
    ExcelSetCellFormula(Int16,Int32,Int32,String) 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 formula As String _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelBiffRead
    Dim sheet As Short
    Dim row As Integer
    Dim col As Integer
    Dim formula As String
    Dim value As Boolean
     
    value = instance.ExcelSetCellFormula(sheet, row, col, formula)
    bool ExcelSetCellFormula( 
       short sheet,
       int row,
       int col,
       string formula
    )

    Parameters

    sheet
    Sheet index
    row
    Row index
    col
    Column index
    formula
    Formula string
    See Also