Add blank rows to a sheet, moving existing rows down
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | — |
Insert At Row startRow | number | Required | — | Rows at and below this move down. Row 1 is the first row. |
Number of Rows rowCount | number | Optional | 1 | — |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Delete WorkSheet Columns
Remove specific columns from a sheet
Delete WorkSheet Rows
Remove specific rows from a sheet
Insert Columns
Add blank columns to a sheet, moving existing columns right
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today