Worksheet.AddCellFormula Method (String, String)

PicoXLSX

PicoXLSX

WorksheetAddCellFormula Method (String, String)

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,
	string address
)

Parameters

formula
Type: SystemString
Formula to insert
address
Type: SystemString
Cell address in the format A1 - XFD1048576
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
FormatExceptionThrows a FormatException if the passed cell address is malformed
See Also