Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Using Get number of rows action

  • Updated: 1/15/2021
    • Automation 360 v.x
    • Build
    • RPA Workspace

Using Get number of rows action

Use the Get number of rows action to get the number of rows that contain data.

To get the number of rows that are not empty or contain data, do the following:

Procedure

  1. Double-click or drag the Get number of rows action from the Excel node in the Actions palette.
  2. Select the Index option to specify the number of the worksheet or the Name option to specify the name of the worksheet from which you want to get the number or rows.
  3. Select the Non-empty rows option to get the number of rows that are not empty or the Total rows with data option to get the number of rows that contain data.
  4. Enter the name of the session used to open the workbook with the Open action.
  5. Select the number variable you want to use to store the output from the Assign to variable list.
  6. Click Save.
Send Feedback