Class 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, column counts starts with 1. 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 - row count starts with 1. 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, column count starts with 1
Declaration
public int StartColumn { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 |
StartRow
The start row, row count starts with 1
Declaration
public int StartRow { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 |