Adds rows to a DataTableRange's sheet range.
Overload Name | Description |
---|---|
RangeAddress | Adds rows to a DataTableRange's sheet range. The rows are added to the DataTableRange's sheet range that contains the specified range's row and column. |
RangeName | Adds rows to a DataTableRange's sheet range. |
Adds rows to a DataTableRange's sheet range. The rows are added to the DataTableRange's sheet range that contains the specified range's row and column.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataTableRangeAddress | The address that is used to identify the DataTableRange whose sheet range the rows are added to. For example, the address of the active cell can be used to identify the selected DataTableRange. |
RowCount | The number of rows to add. |
Adds rows to a DataTableRange's sheet range.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataSetRangeName | The name of the view's SQLPassthroughDataSetRange that contains the DataTableRange definition. |
DataTableRangeName | The name of the DataTableRange whose sheet range the rows are added to. |
GroupSheetRangeName | For a DataTableRange that is configured to sort and/or group the DataTable rows, the name of the group's sheet range to which the rows are added. |
RowCount | The number of rows to add. |