Worksheet.AddCellFormula Method (String, String, Style)

PicoXLSX

PicoXLSX

WorksheetAddCellFormula Method (String, String, 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#
public void AddCellFormula(
	string formula,
	string address,
	Style style
)

Parameters

formula
Type: SystemString
Formula to insert
address
Type: SystemString
Cell address in the format A1 - XFD1048576
style
Type: PicoXLSXStyle
Style to apply on the cell
Exceptions
ExceptionCondition
StyleExceptionThrows an UndefinedStyleException if the passed style was malformed
RangeExceptionThrows an RangeException if the passed cell address is out of range
FormatExceptionThrows a FormatException if the passed cell address is malformed
See Also