Access password protected worksheet |
Accesses a password-protected worksheet in the current
workbook.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Enter the password to access the worksheet.
|
Append worksheet |
See Using Append worksheet action. |
Create worksheet |
Creates a worksheet in the current workbook.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Specify either an index number in
the Sheet by Index field or a
name in the Sheet by Name
field for the worksheet. 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.
|
Delete worksheet |
Deletes a spreadsheet from the
current workbook. |
Disable or enable real-time screen update |
Disables the real-time screen
update.
- Select the Disable option to
disable real-time screen update when you perform actions in a Microsoft Excel worksheet
with large data sets.
- Select the Enable option to
re-enable real-time screen update for other, subsequent
actions.
- Enclose the action that has performance
issues within the Disable or enable real-time
screen update
action.
For example, if you are using
the Run macro
action to run a macro on a worksheet
that has large data sets and if you are facing
performance issues, use the Disable or
enable real-time screen update
action before the Run
macro
action and select the Disable
option to disable real-time screen update for
enhanced performance. Use the Disable or
enable real-time screen update
action again after the Run
macro
action and select the Enable
option to re-enable real-time screen update for
other, subsequent actions.
Important: We recommend using this action only if you face performance issues when you run actions with large data sets. |
Get current worksheet name |
Gets the name of the current worksheet and assigns it to a
string variable.
- 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.
The
Control Room shows a descriptive
default variable name. If you create several output
variables, subsequent variable names are appended
with a -1, -2, -3, and so
on to avoid duplication.
|
Get worksheet as data table |
Gets data from a worksheet and saves it in a table
variable.
- Specify either an index number in
the Sheet by Index field or a
name in the Sheet by Name
field for the worksheet. 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.
- Choose from the
Read option to read either
the visible text or value of the cell.
For example,
if the cell has 70% as cell content, Read
cell value option will read the value
as 70 ignoring the % format whereas Read
visible text option will read the
content as 70%. Recommendation: Use option Read cell
value as reading value from a cell
gives better performance than reading a visible
text.
- Enter
the name of the session used to open the workbook
with the Open
action.
- Select a table variable that you want to use to store
the data from the worksheet from the Assign
value to the variable list. The
Control Room shows a descriptive
default variable name. If you create several output
variables, subsequent variable names are appended
with a -1, -2, -3, and so
on to avoid duplication.
|
Get worksheet names |
Gets the names of all the
worksheets and assigns them to a list variable of string
data type.
- 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. The
Control Room shows a descriptive
default variable name. If you create several output
variables, subsequent variable names are appended
with a -1, -2, -3, and so
on to avoid duplication.
|
Hide worksheet |
Hides a worksheet from the current
workbook.
|
Password protect worksheet |
Protects a worksheet with a password. You can also specify
the operations to restrict on the worksheet.
- Specify the password you want to use to protect the
worksheet and select the check boxes for the operation
that you want to restrict on the worksheet. For example,
select the Delete row and
Delete column check boxes to
restrict a user from deleting a row or column from the
worksheet.
- Enter
the name of the session used to open the workbook
with the Open
action.
|
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 sheets 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. The
Control Room shows a descriptive
default variable name. If you create several output
variables, subsequent variable names are appended
with a -1, -2, -3, and so
on to avoid duplication.
|