Worksheet.AddCellRange Method (List(Object), String)

PicoXLSX

previous page next page

PicoXLSX Library Documentation

WorksheetAddCellRange Method (ListObject, String)

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: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)

Syntax

Copy

public void AddCellRange(
	List<Object> values,
	string cellRange
)

Parameters

values: Type: System.Collections.GenericListObject
List of unspecified objects to insert
cellRange: Type: SystemString
Cell range as string in the format like A1:D1 or X10:X22

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 active style cannot be referenced while creating the cells
FormatException	Throws 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, bool. All other types will be casted into a string using the default ToString() method

Reference

Worksheet Class

AddCellRange Overload

PicoXLSX Namespace

previous page start next page