-
dotnet-standard-api
-
C1.Excel Assembly
-
C1.Excel
-
Classes
- C1XLBook
- ShapeCollection
- XLBorderFormatting
- XLCell
- XLCellRange
- XLCellRangeCollection
- XLColumn
- XLColumnCollection
- XLComment
- XLCommentCollection
- XLCommentShape
- XLConditionalFormatting
- XLConditionalFormattingCollection
- XLConditionalFormattingRangeCollection
- XLConditionalFormattingRule
- XLConditionalFormattingRuleCollection
- XLDataValidation
- XLDataValidationCollection
- XLDataValidationRangeCollection
- XLExternalBook
- XLExternalBookCollection
- XLExternalSheet
- XLFont
- XLFontFormatting
- XLNamedRange
- XLNamedRangeCollection
- XLOpaqueShape
- XLPatternFormatting
- XLPictureShape
- XLPrintSettings
- XLProgressEventArgs
- XLRange
- XLRow
- XLRowCollection
- XLShape
- XLSheet
- XLSheetCollection
- XLStyle
- XLTextShape
- Structs
- Enums
- Delegates
-
Classes
- C1.Util
-
C1.Excel
-
C1.Excel Assembly
C1.Excel.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)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)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
<p>The maximum number of <xref href="C1.Excel.XLRow" data-throw-if-not-resolved="false"></xref> objects in a <xref href="C1.Excel.XLSheet" data-throw-if-not-resolved="false"></xref>
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.