ETLBox ETLBox

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
TypeNameDescription
System.Int32startColumn
System.Int32startRow

ExcelRange(Int32, Int32, Int32, Int32)

Declaration
    public ExcelRange(int startColumn, int startRow, int endColumn, int endRow)
Parameters
TypeNameDescription
System.Int32startColumn
System.Int32startRow
System.Int32endColumn
System.Int32endRow

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
TypeDescription
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
TypeDescription
System.Nullable<System.Int32>

StartColumn

The start column, column count starts with 1

Declaration
    public int StartColumn { get; set; }
Property Value
TypeDescription
System.Int32

StartRow

The start row, row count starts with 1

Declaration
    public int StartRow { get; set; }
Property Value
TypeDescription
System.Int32