Make a copy of an existing sheet
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Source Sheet sourceSheetName | string | Required | Not set | |
New Sheet Name newSheetName | string | Required | Not set |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Delete Excel WorkSheet
Remove a sheet from an Excel workbook
Freeze Panes
Keep the headings on screen while the rest of the sheet scrolls
Get Used Range
Find where the data on a sheet starts and ends. Worked out from cells that hold something, so a cell that was formatted and then emptied does not count
Hide Rows, Columns or Sheets
Hide working rows, columns or sheets without deleting them, so the formulas that depend on them still work
Protect Worksheet
Stop a sheet being edited by accident. This is not security: an Excel sheet password is trivially removed, so use it to protect a report from mistakes rather than to keep a secret