ETLBoxClass ExcelRange
Defines a range in an excel file where the data is located.
Inheritance
System.Object
ExcelRange
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.DataFlow
Assembly: ETLBox.Excel.dll
Syntax
public class ExcelRange
Constructors
ExcelRange(Int32, Int32)
Declaration
public ExcelRange(int startColumn, int startRow)
Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | startColumn | |
| System.Int32 | startRow |
ExcelRange(Int32, Int32, Int32, Int32)
Declaration
public ExcelRange(int startColumn, int startRow, int endColumn, int endRow)
Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | startColumn | |
| System.Int32 | startRow | |
| System.Int32 | endColumn | |
| System.Int32 | endRow |
Properties
EndColumn
The end column, starting with 0. This is optional - if left empty, data will be read until the first blank row is found.
Declaration
public int? EndColumn { get; set; }
Property Value
| Type | Description |
|---|---|
| System.Nullable<System.Int32> |
EndRow
The end row, starting with 0 This is optional - if left empty, data will be read until the first blank row is found.
Declaration
public int? EndRow { get; set; }
Property Value
| Type | Description |
|---|---|
| System.Nullable<System.Int32> |
StartColumn
The start column, starting with 0
Declaration
public int StartColumn { get; set; }
Property Value
| Type | Description |
|---|---|
| System.Int32 |
StartRow
The start row, starting with 0
Declaration
public int StartRow { get; set; }
Property Value
| Type | Description |
|---|---|
| System.Int32 |