Class ExcelRange

Defines a range in an excel file where the data is located.

Inheritance
object
ExcelRange
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.DataFlow
Assembly: ETLBox.Excel.dll
Syntax
    public class ExcelRange

Constructors

ExcelRange(int, int, int, int)

Declaration
    public ExcelRange(int startColumn, int startRow, int endColumn, int endRow)
Parameters
TypeNameDescription
intstartColumn
intstartRow
intendColumn
intendRow

ExcelRange(int, int)

Declaration
    public ExcelRange(int startColumn, int startRow)
Parameters
TypeNameDescription
intstartColumn
intstartRow

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
int?

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
int?

StartColumn

The start column, column count starts with 1

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

StartRow

The start row, row count starts with 1

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