Definition and Usage
The Insert rows to Excel worksheet command is used to insert blank rows into the target Excel sheet.
Note: An Insert rows to Excel worksheet command must to used with a Launch Excel command.
Parameter Values
Set parameters
Parameter | Description |
Excel object | Select the target Excel object to insert rows. |
Insert mode | Select to insert the rows below or above the target row. |
Row number | Specify the position of the target row. Enter a non-zero integer. 1 means the first row and -1 means the last row. The blank rows will be inserted below or above this row. |
No. of rows | Specify how many rows to insert. |
Sheet name (optional) | Enter the name of the target worksheet. If empty, the current active sheet will be selected. |
Error Handling
Parameter | Description |
When error occurs | Specify the action to proceed when an error occurs. |
Example
This workflow will open the Task.xls file and insert a blank row below the first row of the SheetA in this file.