Skip to content

StateDMI / Command / InsertTableRow


Overview

The InsertTableRow inserts 1+ rows in a table. This command has been created to assign blank values for use with the WriteTableCellsToExcel command, for example to clear out named cells in an Excel workbook.

Command Editor

The following dialog is used to edit the command and illustrates the syntax of the command. See also the full-size image.

InsertTableRow

InsertTableRow Command Editor

Command Syntax

The command syntax is as follows:

InsertTableRow(Parameter="Value",...)

Command Parameters

Parameter                           Description Default                
TableID The identifier for the table being modified. None – must be specified.
InsertRow The row number (1+) to insert before. The row will be appended to the end of the table.
InsertCount The number of times the insert should be repeated. 1
ColumnValues The column names and corresponding values to set using syntax:
ColumnName1:Value1, ColumnName2:Value2
The column name and value parts can be specified using ${Property} notation.
No values will be assigned (will be null values).

Examples

See the automated tests.

Troubleshooting

See Also