Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Table operations

  • Updated: 5/06/2020
    • Automation 360 v.x
    • Build
    • RPA Workspace

Table operations

The Office 365 Excel package contains various actions that you can use to automate tasks related to the table operations such as create, delete, filter, get properties, rename, and sort.

The Office 365 Excel package includes the following actions:

Actions Description
Create table Creates a new table in the specified table range.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the table name.
  • Enter the cell range in which to create the table. For example, A1:D4.
  • Optional: Select the Table has headers option to establish the first row as the header row.
Delete table Deletes the table in the active worksheet.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the table name.
Get table column Retrieves the column values of a specified table and column index, and assigns the values to a List variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the table name.
  • Enter the column index. For example, enter 5 to indicate the fifth column from the left.
  • Select a List variable to store the values.
Get table names Retrieves the names of all the tables in a workbook and assigns them to a List variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Optional: Select whether to specify a sheet either by index or name.
  • Select a List variable to store the values.
Get table row Retrieves the row values of a specified table and row index, and assigns the values to a Record variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the table name.
  • Enter the row index. For example, enter 5 to indicate the fifth row from the top.
  • Select a Record variable to store the values.
Get table row count Retrieves the row count of a specified table and assigns the values to a number variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the table name.
  • Select a Number type variable to store the values. To convert the variable to a String type variable, see the Number > Convert action.
Rename table Renames a table.
  • Enter the name of the session used to open the workbook with the Open action.
  • Enter the current table name.
  • Enter a new table name.
Send Feedback