| Copy worksheet |
See Using the Copy worksheet action.
|
| Create worksheet |
Adds an empty sheet in the current workbook.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Enter a Worksheet name of up to 31
characters. The name cannot contain the following
characters: \ / ? * [ ]
|
| Delete worksheet |
Deletes a spreadsheet from the
current workbook.
|
| Get current worksheet name |
Retrieves the name of the currently active worksheet.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Select a string variable that you want to use to
store the name of the worksheet from the
Assign the output to
variable list.
|
| Get worksheet names |
Retrieves the names of all the worksheets in the workbook.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Select a list variable to store the worksheet names from the
Assign the output to variable
list.
|
| Hide worksheet |
Hides a worksheet from the current
workbook.
|
| Rename worksheet |
Renames a worksheet in the current
workbook.
- Specify the index number or name of the worksheet to
rename in the Sheet by Index or
Sheet by Name field.
The
index number is the number assigned to a worksheet.
For example, if you want to perform an operation on
the worksheet at the third position in the workbook,
enter 3 in the field. Note: You cannot
rename the worksheet if a worksheet with the same
name already exists in the
workbook.
- Enter the new worksheet name that is under 31
characters.
- Enter
the name of the session used to open the workbook
with the Open
action.
|
| Retrieve sheet count |
Gets the number of sheets
available in the current workbook and stores it in a number
variable.
- Select the appropriate option to specify whether to
include the hidden worksheet or not and assign the count
to a variable.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Select a number variable that you want to use to
store the name of the worksheet from the
Select the variable to assign
to list.
|
| Show worksheet |
Shows the hidden worksheet.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Enter the Worksheet name.
|
| Switch to sheet |
Activates a particular sheet in a
Microsoft Excel file.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Specify whether to activate the Sheet by
Index (numerical value) or
Sheet by Name.
|