Click or drag to resize
NanoXLSX

WorksheetAddCellRange(IReadOnlyListObject, String, 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,
	string cellRange,
	Style style
)

Parameters

values  IReadOnlyListObject
List of unspecified objects to insert
cellRange  String
Cell range as string in the format like A1:D1 or X10:X22
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
FormatExceptionThrows a FormatException if the passed cell range 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