Worksheet.AddCellRange Method (List(Object), Cell.Address, Cell.Address, Style)

NanoXLSX

previous page next page

NanoXLSX Library Documentation

WorksheetAddCellRange Method (ListObject, CellAddress, CellAddress, Style)

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 casted to a String. Prepared objects of the type Cell will not be casted but adjusted

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)

Syntax

Copy

public void AddCellRange(
	List<Object> values,
	CellAddress startAddress,
	CellAddress endAddress,
	Style style
)

Parameters

values: Type: System.Collections.GenericListObject
List of unspecified objects to insert
startAddress: Type: NanoXLSXCellAddress
Start address
endAddress: Type: NanoXLSXCellAddress
End address
style: Type: NanoXLSX.StyleStyle
Style to apply on the all cells of the range

Exceptions

Exception	Condition
RangeException	Throws an RangeException if the number of cells resolved from the range differs from the number of passed values
StyleException	Throws an UndefinedStyleException 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, bool. All other types will be casted into a string using the default ToString() method

Reference

Worksheet Class

AddCellRange Overload

NanoXLSX Namespace

previous page start next page