ExcelSetCellValueAndFormula Method

In This Topic

Excels the set cell value and formula.

Syntax

Visual Basic
C#

'Declaration
 
Function ExcelSetCellValueAndFormula( _
   ByVal sheet As Short, _
   ByVal row As Integer, _
   ByVal col As Integer, _
   ByVal value As Object, _
   ByVal styleInfo As Object, _
   ByVal rdr As BinaryReader, _
   ByVal rdrExtra As BinaryReader, _
   ByVal rowFirst As Integer, _
   ByVal colFirst As Integer _
) As Boolean

'Usage
 
Dim instance As IOptimizedExcel4
Dim sheet As Short
Dim row As Integer
Dim col As Integer
Dim value As Object
Dim styleInfo As Object
Dim rdr As BinaryReader
Dim rdrExtra As BinaryReader
Dim rowFirst As Integer
Dim colFirst As Integer
Dim value As Boolean
 
value = instance.ExcelSetCellValueAndFormula(sheet, row, col, value, styleInfo, rdr, rdrExtra, rowFirst, colFirst)

bool ExcelSetCellValueAndFormula( 
   short sheet,
   int row,
   int col,
   object value,
   object styleInfo,
   BinaryReader rdr,
   BinaryReader rdrExtra,
   int rowFirst,
   int colFirst
)

Parameters

sheet
row: The row.
col: The col.
value: The value.
styleInfo: The style info.
rdr
rdrExtra
rowFirst
colFirst

Reference

IOptimizedExcel4 Interface
IOptimizedExcel4 Members