XlsWorksheet
SetFormula Method (Int32, Int32, String, Boolean)
|
Sets formula in the specified cell.
Namespace:
Spire.Xls.Core.Spreadsheet
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void SetFormula(
int iRow,
int iColumn,
string value,
bool bIsR1C1
)
Public Sub SetFormula (
iRow As Integer,
iColumn As Integer,
value As String,
bIsR1C1 As Boolean
)
public:
void SetFormula(
int iRow,
int iColumn,
String^ value,
bool bIsR1C1
)
member SetFormula :
iRow : int *
iColumn : int *
value : string *
bIsR1C1 : bool -> unit
Parameters
-
iRow
-
Type:
System
Int32
One-based row indexof the cell to set value.
-
iColumn
-
Type:
System
Int32
One-based column index of the cell to set value.
-
value
-
Type:
System
String
Formula to set.
-
bIsR1C1
-
Type:
System
Boolean
Indicates is formula in R1C1 notation.
See Also