Worksheet operations
The Office 365 Excel package contains actions that you can use to automate tasks related to worksheet operations, such as delete, find, get worksheet names, hide, retrieve worksheet count, and show.
The Office 365 Excel package includes the following actions:
Actions | Description |
---|---|
Copy worksheet | |
Create worksheet | Adds an empty sheet in the current workbook.
|
Delete worksheet | Deletes a spreadsheet from the
current workbook.
|
Get current worksheet name | Retrieves the name of the currently active worksheet.
|
Get worksheet names | Retrieves the names of all the worksheets in the workbook.
|
Hide worksheet | Hides a worksheet from the current
workbook.
|
Rename worksheet | Renames a worksheet in the current
workbook.
|
Retrieve sheet count | Gets the number of sheets
available in the current workbook and stores it in a number
variable.
|
Show worksheet | Shows the hidden worksheet.
|
Switch to sheet | Activates a particular sheet in a
Microsoft Excel file.
|