-
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.-ctor
XLCellRange Constructor
XLCellRange()
Creates an instance of an XLCellRange object containing an empty range.
Declaration
public XLCellRange()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)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)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)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)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)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)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)Parameters
| Type | Name | Description |
|---|---|---|
| C1XLBook | book | The owner workbook for the range. |
| string | reference | The text presentation of a specified range. |