Click or drag to resize
NanoXLSX

WorksheetAddCellRange(IReadOnlyListObject, Address, Address) Method

Adds a list of object values to a defined cell range. If the type of the a particular value does not match with one of the supported data types, it will be cast to a String. Prepared objects of the type Cell will not be cast but adjusted

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
public void AddCellRange(
	IReadOnlyList<Object> values,
	Address startAddress,
	Address endAddress
)

Parameters

values  IReadOnlyListObject
List of unspecified objects to insert
startAddress  Address
Start address
endAddress  Address
End address
Exceptions
ExceptionCondition
RangeExceptionThrows a RangeException if the number of cells resolved from the range differs from the number of passed values
Remarks
The data types in the passed list can be mixed. Recognized are the following data types: string, int, double, float, long, DateTime, TimeSpan, bool. All other types will be cast into a string using the default ToString() method
See Also