Worksheet operations

Read and Review Automation Anywhere Documentation

Automation 360

Download PDF

Worksheet operations

The Office 365 Excel package contains actions that you can use to automate tasks related to worksheet operations, such as delete, find, get worksheet names, hide, retrieve worksheet count, and show.

The Office 365 Excel package includes the following actions:


Actions	Description
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. 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.
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. 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	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. 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.
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. 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.
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.

Send Feedback