ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLRowCollection Class / Insert Method / Insert(Int32,XLRow) Method
Position where the item will be inserted.
Item that will be inserted.

In This Topic
    Insert(Int32,XLRow) Method
    In This Topic
    Inserts an XLRow object at a specific position in the collection.
    Syntax
    'Declaration
     
    Public Overloads Function Insert( _
       ByVal index As System.Integer, _
       ByVal row As XLRow _
    ) As XLRow
    public XLRow Insert( 
       System.int index,
       XLRow row
    )

    Parameters

    index
    Position where the item will be inserted.
    row
    Item that will be inserted.

    Return Value

    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.

    See Also