Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Worksheet operations

  • Updated: 2022/03/29
    • Automation 360 v.x
    • Build
    • RPA Workspace

Worksheet operations

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 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.
  • 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.
    Note: You can delete a worksheet only if the workbook contains more than one worksheet.
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.
  • Specify the name of the worksheet to hide in the Enter worksheet name to hide field.
    Note: You can hide a worksheet only if the workbook contains more than one worksheet.
  • Enter the name of the session used to open the workbook with the Open action.
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.