-
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
-
Properties
- Background
- Book
- CodeName
- ColumnMaxLevel
- Columns
- Comments
- ConditionalFormattings
- DataValidations
- DefaultColumnWidth
- DefaultRowHeight
- GridColor
- Locked
- MaxOutlineLevel
- MergedCells
- Name
- OutlinesBelow
- OutlinesRight
- PageBreakPreview
- PrintSettings
- RowMaxLevel
- Rows
- Scale
- ScaleNormal
- SelectedCells
- Shapes
- ShowGridLines
- ShowHeaders
- ShowZeros
- TabColor
- TotalsBelowData
- ViewLayout
- Visible
- this
- Methods
-
Properties
- XLSheetCollection
- XLStyle
- XLTextShape
- Structs
- Enums
- Delegates
-
Classes
- C1.Util
-
C1.Excel
-
C1.Excel Assembly
C1.Excel.XLSheet.Item
this Property
this[int, int]
Gets the cell at a specified position on the sheet, creating a new cell if necessary.
Declaration
public XLCell this[int rowIndex, int colIndex] { get; }Parameters
| Type | Name | Description |
|---|---|---|
| int | rowIndex | |
| int | colIndex |
Remarks
<p>If the specified cell doesn't exist when the indexer is invoked, the sheet will be expanded and
a new cell will be created, then returned. This makes it easy to create and populate sheets.
If you want to determine whether a specific cell has been defined, use the GetCell(int, int) method instead.
The indexer is generally more useful when creating and populating sheets. The GetCell(int, int) method is more useful when loading existing sheets.