[]
DEMOS DOCS API SAMPLES DOWNLOAD
(Showing Draft Content)

C1.C1Excel.XLRowCollection.Insert

Insert Method

Insert(int)

Creates a new XLRow object and inserts it at a specific position in the collection.

Declaration
public XLRow Insert(int index)
Public Function Insert(index As Integer) As XLRow
Parameters
Type Name Description
int index

Position where the new item will be inserted.
Returns
Type Description
XLRow

A reference to the new item.

Insert(int, XLRow)

Inserts an XLRow object at a specific position in the collection.

Declaration
public XLRow Insert(int index, XLRow row)
Public Function Insert(index As Integer, row As XLRow) As XLRow
Parameters
Type Name Description
int index

Position where the item will be inserted.
XLRow row

Item that will be inserted.
Returns
Type Description
XLRow

A reference to the item that was added to the collection.
Remarks

The maximum number of XLRow objects in a XLSheet is 65,536. This is a limitation imposed by Excel 2003 and below.

For Excel 2007 and above, the maximum number of XLRow objects in an XLSheet is 1,048,576.