-
dotnet-framework-api
-
C1.WPF.Excel.4.6.2 Assembly
-
C1.WPF.Excel
-
Classes
- C1XLBook
- ShapeCollection
- XLBorderFormatting
- XLCell
- XLCellRange
- XLCellRangeCollection
- XLColumn
- XLColumnCollection
- XLComment
- XLCommentCollection
- XLCommentShape
- XLConditionalFormatting
- XLConditionalFormattingCollection
- XLConditionalFormattingRangeCollection
- XLConditionalFormattingRule
- XLConditionalFormattingRuleCollection
- XLDataValidation
- XLDataValidationCollection
- XLDataValidationRangeCollection
- XLFont
- XLFontFormatting
- XLNamedRange
- XLNamedRangeCollection
- XLOpaqueShape
- XLPatternFormatting
- XLPictureShape
- XLPrintSettings
- XLProgressEventArgs
- XLRange
- XLRow
- XLRowCollection
- XLShape
- XLSheet
- XLSheetCollection
- XLStyle
- XLTextShape
- Enums
- Interfaces
- Delegates
-
Classes
-
C1.WPF.Excel
-
C1.WPF.Excel.4.6.2 Assembly
C1.WPF.Excel.XLCellRange.-ctor
XLCellRange Constructor
XLCellRange()
Creates an instance of an XLCellRange object containing an empty range.
Declaration
public XLCellRange()Public Sub New()XLCellRange(int, int, int, int)
Creates an instance of an XLCellRange object containing a specified range.
Declaration
public XLCellRange(int rowFrom, int rowTo, int colFrom, int colTo)Public Sub New(rowFrom As Integer, rowTo As Integer, colFrom As Integer, colTo As Integer)Parameters
| Type | Name | Description |
|---|---|---|
| int | rowFrom | Top row in the range. |
| int | rowTo | Bottom row in the range. |
| int | colFrom | Left column in the range. |
| int | colTo | Right column in the range. |
XLCellRange(XLSheet, int, int, int, int)
Creates an instance of an XLCellRange object containing a specified range.
Declaration
public XLCellRange(XLSheet sheet, int rowFrom, int rowTo, int colFrom, int colTo)Public Sub New(sheet As XLSheet, rowFrom As Integer, rowTo As Integer, colFrom As Integer, colTo As Integer)Parameters
| Type | Name | Description |
|---|---|---|
| XLSheet | sheet | The XLSheet of this cell range. |
| int | rowFrom | Top row in the range. |
| int | rowTo | Bottom row in the range. |
| int | colFrom | Left column in the range. |
| int | colTo | Right column in the range. |
XLCellRange(XLSheet, int, int, int, int, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType)
Creates an instance of an XLCellRange object containing a specified range.
Declaration
public XLCellRange(XLSheet sheet, int rowFrom, int rowTo, int colFrom, int colTo, XLReferenceType rowFromRef, XLReferenceType rowToRef, XLReferenceType colFromRef, XLReferenceType colToRef)Public Sub New(sheet As XLSheet, rowFrom As Integer, rowTo As Integer, colFrom As Integer, colTo As Integer, rowFromRef As XLReferenceType, rowToRef As XLReferenceType, colFromRef As XLReferenceType, colToRef As XLReferenceType)Parameters
| Type | Name | Description |
|---|---|---|
| XLSheet | sheet | The XLSheet of this cell range. |
| int | rowFrom | T0op row in the range. |
| int | rowTo | Bottom row in the range. |
| int | colFrom | Left column in the range. |
| int | colTo | Right column in the range. |
| XLReferenceType | rowFromRef | The reference type of the top row in the range. |
| XLReferenceType | rowToRef | The reference type of the bottom row in the range. |
| XLReferenceType | colFromRef | The reference type of the left column in the range. |
| XLReferenceType | colToRef | The reference type of the right column in the range. |
XLCellRange(XLSheet, int, int, XLReferenceType, XLReferenceType)
Creates an instance of an XLCellRange object containing a specified range.
Declaration
public XLCellRange(XLSheet ws, int row, int col, XLReferenceType rowRef, XLReferenceType colRef)Public Sub New(ws As XLSheet, row As Integer, col As Integer, rowRef As XLReferenceType, colRef As XLReferenceType)Parameters
| Type | Name | Description |
|---|---|---|
| XLSheet | ws | The XLSheet of the range. |
| int | row | The row in the range equal one cell. |
| int | col | The column in the range equal one cell. |
| XLReferenceType | rowRef | The reference type of the row. |
| XLReferenceType | colRef | The reference type of the column. |
XLCellRange(int, int, int, int, int, int, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType)
Creates an instance of an XLCellRange object containing a specified range.
Declaration
public XLCellRange(int sheetFrom, int sheetTo, int rowFrom, int rowTo, int colFrom, int colTo, XLReferenceType rowFromRef, XLReferenceType rowToRef, XLReferenceType colFromRef, XLReferenceType colToRef)Public Sub New(sheetFrom As Integer, sheetTo As Integer, rowFrom As Integer, rowTo As Integer, colFrom As Integer, colTo As Integer, rowFromRef As XLReferenceType, rowToRef As XLReferenceType, colFromRef As XLReferenceType, colToRef As XLReferenceType)Parameters
| Type | Name | Description |
|---|---|---|
| int | sheetFrom | First index of the XLSheet of the range. |
| int | sheetTo | Last index of the XLSheet of the range. |
| int | rowFrom | Top row in the range. |
| int | rowTo | Bottom row in the range. |
| int | colFrom | Left column in the range. |
| int | colTo | Right column in the range. |
| XLReferenceType | rowFromRef | The reference type of the top row in the range. |
| XLReferenceType | rowToRef | The reference type of the bottom row in the range. |
| XLReferenceType | colFromRef | The reference type of the left column in the range. |
| XLReferenceType | colToRef | The reference type of the right column in the range. |
XLCellRange(XLSheet, string)
Creates an instance of an XLCellRange object containing a specified range.
Declaration
public XLCellRange(XLSheet sheet, string reference)Public Sub New(sheet As XLSheet, reference As String)Parameters
| Type | Name | Description |
|---|---|---|
| XLSheet | sheet | The owner sheet for the range. |
| string | reference | The text presentation of a specified range without sheets. |
XLCellRange(C1XLBook, string)
Creates an instance of an XLCellRange object containing a specified range.
Declaration
public XLCellRange(C1XLBook book, string reference)Public Sub New(book As C1XLBook, reference As String)Parameters
| Type | Name | Description |
|---|---|---|
| C1XLBook | book | The owner workbook for the range. |
| string | reference | The text presentation of a specified range. |