Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Table operations

  • Updated: 2022/05/06

    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.
    Important: Ensure that Microsoft Excel is set to the same language as that of the computer operating system.
    Send Feedback