ExcelRange

Class ExcelRange

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

Inheritance
ExcelRange
Namespace: ETLBox.Excel
Assembly: ETLBox.Excel.dll
Syntax
    public class ExcelRange

Constructors

ExcelRange(int, int)

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

ExcelRange(int, int, int, int)

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

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