Worksheet.AddCell Method (Object, String)

PicoXLSX

PicoXLSX

WorksheetAddCell Method (Object, String)

Adds an object to the defined cell address. If the type of the value does not match with one of the supported data types, it will be casted to a String. A prepared object of the type Cell will not be casted but adjusted

Namespace:  PicoXLSX
Assembly:  PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)
Syntax
C#
public void AddCell(
	Object value,
	string address
)

Parameters

value
Type: SystemObject
Unspecified value 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
Remarks
Recognized are the following data types: Cell (prepared object), string, int, double, float, long, DateTime, bool. All other types will be casted into a string using the default ToString() method
See Also