Worksheet.AddCellFormula Method (String, Int32, Int32, Style)

PicoXLSX

previous page next page
PicoXLSX

WorksheetAddCellFormula Method (String, Int32, Int32, Style)

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#
Copy
public void AddCellFormula(
	string formula,
	int columnAddress,
	int rowAddress,
	Style style
)

Parameters

formula
Type: SystemString
Formula to insert
columnAddress
Type: SystemInt32
Column number (zero based)
rowAddress
Type: SystemInt32
Row number (zero based)
style
Type: PicoXLSXStyle
Style to apply on the cell
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
previous page start next page