Spread WPF 17
GrapeCity.Excel Namespace / IExcelReader Interface / SetCellFormula Method
The zero based sheet index used to locate the IExcelWorkbook instance
The zero based cell row index
The zero based cell column index
The formula used to set the value


In This Topic
    SetCellFormula Method
    In This Topic
    Set formula for a specified cell.
    Syntax
    'Declaration
 
Function SetCellFormula( _
   ByVal sheet As Short, _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal cellFormula As IExcelFormula _
) As Boolean
    'Usage
 
Dim instance As IExcelReader
Dim sheet As Short
Dim row As Integer
Dim column As Integer
Dim cellFormula As IExcelFormula
Dim value As Boolean
 
value = instance.SetCellFormula(sheet, row, column, cellFormula)
    bool SetCellFormula( 
   short sheet,
   int row,
   int column,
   IExcelFormula cellFormula
)

    Parameters

    sheet
    The zero based sheet index used to locate the IExcelWorkbook instance
    row
    The zero based cell row index
    column
    The zero based cell column index
    cellFormula
    The formula used to set the value

    Return Value

    true If the cell is in a valid cell in the specified worksheet, otherwise, false
    Exceptions
    ExceptionDescription
    System.ArgumentNullExceptionthrows if the formula is null or empty.
    See Also

    Reference

    IExcelReader Interface
    IExcelReader Members