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:

ActionDescription
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