Worksheet.AddCellFormula Method (String, String)

NanoXLSX

previous page next page
NanoXLSX

WorksheetAddCellFormula Method (String, String)

Adds a cell formula as string to the defined cell address

Namespace:  NanoXLSX
Assembly:  NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)
Syntax
C#
Copy
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
previous page start next page