Worksheet.AddCellFormula Method (String, Int32, Int32)

PicoXLSX

PicoXLSX

WorksheetAddCellFormula Method (String, Int32, Int32)

Adds a cell formula as string to the defined cell address

Namespace:  PicoXLSX
Assembly:  PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)
Syntax
C#
public void AddCellFormula(
	string formula,
	int columnAddress,
	int rowAddress
)

Parameters

formula
Type: SystemString
Formula to insert
columnAddress
Type: SystemInt32
Column number (zero based)
rowAddress
Type: SystemInt32
Row number (zero based)
Exceptions
ExceptionCondition
StyleExceptionThrows an UndefinedStyleException if the active style cannot be referenced while creating the cell
RangeExceptionThrows an RangeException if the passed cell address is out of range
See Also