Spread WinForms 15
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)

Parameters

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