Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Column/Row operations

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

Column/Row operations

The Office 365 Excel package contains actions that you can use to automate tasks related to column and row operations such as autofit, delete, insert, and read.

The Office 365 Excel package includes the following actions:

Actions Description
Autofit columns Adjusts the width of the columns in the worksheet in the specified session. Use Enter the name of the session used to open the workbook with the Open action.
Autofit rows Adjusts the height of the rows in the worksheet in the specified session. Use Enter the name of the session used to open the workbook with the Open action.
Delete row/column See Using Delete action for rows or columns.
Get row count Retrieves the number of rows that contain data in the worksheet.
  • Enter the name of the session used to open the workbook with the Open action.
  • Assign the output value to a Number variable. To convert the variable to a String variable, see the Number > Convert action.
Insert row/column See Using Insert action for rows or columns.
Read column Extracts data from a column and stores it in a List variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the From active cell or From specific cell option to specify the starting point.
  • You can also select the Read full column option to extract data for the entire column.
  • Assign the output value to a List variable.
Read row Extracts data from a row and stores it in a Record variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select the From active cell or From specific cell option to specify the starting point.
  • You can also select the Read full row option to extract data for the entire row.
  • Assign the output value to a Record variable.
Send Feedback