Click or drag to resize
NanoXLSX

WorksheetAddCellRange(IReadOnlyListObject, Address, Address, Style) 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#
Copy
public void AddCellRange(
	IReadOnlyList<Object> values,
	Address startAddress,
	Address endAddress,
	Style style
)

Parameters

values  IReadOnlyListObject
List of unspecified objects to insert
startAddress  Address
Start address
endAddress  Address
End address
style  Style
Style to apply on the all cells of the range
Exceptions
ExceptionCondition
RangeExceptionThrows a RangeException if the number of cells resolved from the range differs from the number of passed values
StyleExceptionThrows a StyleException if the passed style is malformed
Remarks
The data types in the passed list can be mixed. 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
See Also