Worksheet operations in Excel advanced

The Excel advanced package contains various actions that you can use to automate worksheet-related tasks.

Worksheet actions in the Excel advanced package

The Excel advanced package includes the following actions:


Action	Description
Access password protected worksheet	See Access password protected worksheet action
Append worksheet	See Using Append worksheet action.
Create worksheet	See Create worksheet action
Delete worksheet	See Delete worksheet action
Disable or enable real-time screen update	See Disable or enable real-time screen update action
Get current worksheet name	See Get current worksheet name action
Get worksheet as data table	See Get worksheet as data table action
Get worksheet names	See Get worksheet names action
Hide worksheet	See Hide worksheet action
Password protect worksheet	See Password protect worksheet action
Rename worksheet	See Rename worksheet action
Retrieve sheets count	See Retrieve sheets count action
Run macro	See Run macro action
Switch to sheet	See Switch to sheet action
Unhide all worksheets	See Unhide all worksheets action
Unhide worksheet	See Unhide worksheet action
Write from data table	See Write from data table action