ExcelSetCellFormula Method (IExcelXml)
In This Topic
Sets the Excel XML cell formula.
Syntax
'Declaration
Function ExcelSetCellFormula( _
ByVal As Short, _
ByVal As Integer, _
ByVal As Integer, _
ByVal As String, _
ByVal 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 ,
int ,
int ,
string ,
ArrayList
)
Parameters
- sheet
- Sheet index
- row
- Row index
- col
- Column index
- formula
- Formula
- sharedList
- Shared list
See Also