Click or drag to resize
NanoXLSX

WorksheetAddCellFormula(String, String, Style) Method

Adds a cell formula as string to the defined cell address

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
Copy
public void AddCellFormula(
	string formula,
	string address,
	Style style
)

Parameters

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