PicoXLSX 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: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)
SyntaxC#
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: PicoXLSXCellAddress
Start address - endAddress
- Type: PicoXLSXCellAddress
End address - style
- Type: PicoXLSXStyle
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 |
RemarksThe 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
See Also