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

Namespace:  C1.Silverlight.Excel
Assembly:  C1.Silverlight.Excel.5 (in C1.Silverlight.Excel.5.dll)

Syntax

C#
public XLRow Insert(
	int index,
	XLRow row
)
Visual Basic
Public Function Insert ( _
	index As Integer, _
	row As XLRow _
) As XLRow

Parameters

index
Type: System..::..Int32
Position where the item will be inserted.
row
Type: C1.Silverlight.Excel..::..XLRow
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