Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml Interface / ExcelSetCellFormula Method
Sheet index
Row index
Column index
Formula
Shared list


In This Topic
    ExcelSetCellFormula Method (IExcelXml)
    In This Topic
    Sets the Excel XML cell formula.
    Syntax
    'Declaration
     
    
    Function ExcelSetCellFormula( _
       ByVal sheet As Short, _
       ByVal row As Integer, _
       ByVal col As Integer, _
       ByVal formula As String, _
       ByVal sharedList As ArrayList _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelXml
    Dim sheet As Short
    Dim row As Integer
    Dim col As Integer
    Dim formula As String
    Dim sharedList As ArrayList
    Dim value As Boolean
     
    value = instance.ExcelSetCellFormula(sheet, row, col, formula, sharedList)
    bool ExcelSetCellFormula( 
       short sheet,
       int row,
       int col,
       string formula,
       ArrayList sharedList
    )

    Parameters

    sheet
    Sheet index
    row
    Row index
    col
    Column index
    formula
    Formula
    sharedList
    Shared list
    See Also