-
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.XLCellRange
XLCellRange Class
Implements
Namespace: C1.Excel
Assembly: C1.Excel.dll
Syntax
public class XLCellRange : ICloneableConstructors
| Name | Description |
|---|---|
| XLCellRange() | Creates an instance of an XLCellRange object containing an empty range. |
| XLCellRange(C1XLBook, string) | Creates an instance of an XLCellRange object containing a specified range. |
| XLCellRange(XLSheet, int, int, XLReferenceType, XLReferenceType) | Creates an instance of an XLCellRange object containing a specified range. |
| XLCellRange(XLSheet, int, int, int, int) | Creates an instance of an XLCellRange object containing a specified range. |
| XLCellRange(XLSheet, int, int, int, int, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType) | Creates an instance of an XLCellRange object containing a specified range. |
| XLCellRange(XLSheet, string) | Creates an instance of an XLCellRange object containing a specified range. |
| XLCellRange(int, int, int, int) | Creates an instance of an XLCellRange object containing a specified range. |
| XLCellRange(int, int, int, int, int, int, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType) | Creates an instance of an XLCellRange object containing a specified range. |
Properties
| Name | Description |
|---|---|
| Book | Gets a reference to the parent C1XLBook object. |
| ColumnCount | Gets the number of columns in the range. |
| ColumnFrom | Gets the index of the left column in the range. |
| ColumnFromRef | Gets the reference type of the left column in the range. |
| ColumnTo | Gets or sets the index of the last column in the range. |
| ColumnToRef | Gets the reference type of the right column in the range. |
| IsEmpty | Determines whether the range is empty. |
| RangeType | Gets or sets a type (default, indirect or offset) for this cell range. |
| RowCount | Gets the number of rows in the range. |
| RowFrom | Gets the index of the top row in the range. |
| RowFromRef | Gets the reference type of the top row in the range. |
| RowTo | Gets or sets the index of the last row in the range. |
| RowToRef | Gets the reference type of the bottom row in the range. |
| SheetCount | Gets the number of sheets in the range. |
| SheetFrom | Gets the index of the first sheet in the range. |
| SheetTo | Gets or sets the index of the last sheet in the range. |
| Sheets | Gets an array of XLSheet objects. |
| Style | Gets or sets the XLStyle object associated with this range of cells. |
| Value | Gets or sets the complex value associated with this range of cells. |
Methods
| Name | Description |
|---|---|
| Clone() | Creates a copy of this cell range. |
| Contains(XLCellRange) | Determines whether the range contains a specific range. |
| Contains(XLSheet, int, int) | Determines whether the range contains a specific cell. |
| Intersects(XLCellRange) | Determines whether the range intersects another range. |
| ToA1(int, int, XLReferenceType, XLReferenceType) | Gets string with row and column reference in A1 mode. |
| ToR1C1(int, int, XLReferenceType, XLReferenceType) | Gets string with row and column reference in R1C1 mode. |
| ToString() | Returns a reference string that represents the range. |