Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Table operations

  • Updated: 2/18/2021
    • Automation 360 v.x
    • Build
    • RPA Workspace

Table operations

The Excel advanced package contains various actions that you can use to automate tasks related to table operations in a Microsoft Excel spreadsheet.

Table actions in the Excel advanced package

Note: Ensure that a table is available in the workbook. A worksheet that contains data in various rows and columns is not considered as a table.
The Excel advanced package includes the following actions:
Action Description
Delete table column Deletes a column in a table.
  • Specify the Table name from which you want to delete a column.
    Note: The table name is a string value. It is NOT a data table name. For information on how to retrieve the Excel table name, see Rename an Excel table.
  • Select the Name or Position to specify the name or position of the column to delete.
  • Enter the name of the session used to open the workbook with the Open action.
Filter table See Using Filter table action.
Get table range Gets the range of a table available in a worksheet and stores the output in a string variable.
  • Specify the Table name for which you want to get the range.
    Note: The table name is a string value. It is NOT a data table name. For information on how to retrieve the Excel table name, see Rename an Excel table.
  • Select the options to specify whether you want to include a header and pivot table in the range and a variable to store the output. 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.
  • Enter the name of the session used to open the workbook with the Open action.
Insert table column Inserts a column in a table.
  • Specify the Table name in which you want to insert a column.
    Note: The table name is a string value. It is NOT a data table name. For information on how to retrieve the Excel table name, see Rename an Excel table.
  • Specify the name of the column in the Column name field and the position where you want to insert the column in the Column position field.
  • Enter the name of the session used to open the workbook with the Open action.
Sort table Sorts the data in a column of a table. This action enables you to sort numeric and text data.
  • Specify the Table name for which you want to sort the data.
    Note: The table name is a string value. It is NOT a data table name. For information on how to retrieve the Excel table name, see Rename an Excel table.
  • Select the Column name or Column position to specify the name or position of the column.
  • Select an appropriate option from the Number or Text list to specify the sort order.
  • Enter the name of the session used to open the workbook with the Open action.
Send Feedback