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