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
Type | Name | Description |
---|---|---|
int | startColumn | |
int | startRow | |
int | endColumn | |
int | endRow |
ExcelRange(int, int)
Declaration
public ExcelRange(int startColumn, int startRow)
Parameters
Type | Name | Description |
---|---|---|
int | startColumn | |
int | startRow |
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 |
---|---|
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
Type | Description |
---|---|
int? |
StartColumn
The start column, column count starts with 1
Declaration
public int StartColumn { get; set; }
Property Value
Type | Description |
---|---|
int |
StartRow
The start row, row count starts with 1
Declaration
public int StartRow { get; set; }
Property Value
Type | Description |
---|---|
int |