WorksheetAddCell(Object, String) Method

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 cast to a String. A prepared object of the type Cell will not be cast but adjusted

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.2+7f12a949130e0be1e987e553d2d08c083176cdca

Syntax

Copy

public void AddCell(
	Object value,
	string address
)

Parameters

value Object: Unspecified value to insert
address String: Cell address in the format A1 - XFD1048576

Exceptions

Exception	Condition
RangeException	Throws a RangeException if the passed cell address is out of range
FormatException	Throws 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, TimeSpan, bool. All other types will be cast into a string using the default ToString() method

Reference

Worksheet Class

AddCell Overload

NanoXLSX Namespace