Add blank columns to a sheet, moving existing columns right
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | — |
Insert At Column startColumn | number | Required | — | Columns at and to the right of this move across. Column 1 is A. |
Number of Columns columnCount | number | Optional | 1 | — |
Column Headings headers | array | Optional | — | Optional heading for each new column, written into row 1 |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Delete WorkSheet Columns
Remove specific columns from a sheet
Delete WorkSheet Rows
Remove specific rows from a sheet
Insert Rows
Add blank rows to a sheet, moving existing rows down
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