TExportRange

Description

TExportRange defines a cell range.

Properties

NameTypeDescription
ColIntegerLeft column of the range. If -1 is assigned, no column range is specified.
RowIntegerTop row of the range. If -1 is assigned, no row range is specified.
ColSpanIntegerColumn span of the range.
RowSpanIntegerRow span of the range.
LeftColIntegerSame as Col.
TopRowIntegerSame as Row.
RightColIntegerRight column of the range: RightCol = Col+ColSpan-1.
BottomRowIntegerBottom row of the range BottomRow = Row+RowSpan-1.
WorkSheetTExportWorkSheetTarget export sheet of the range.

Example ranges

RangeTExportRange
A:B (first 2 columns)Col = 0, ColSpan = 2, Row = -1
2:4 (2nd - 4th rows)Row = 1, RowSpan = 3, Col = -1
A2:B4Col = 0, ColSpan = 2, Row = 1, RowSpan = 3
Categories