Actions group Version 9 (Java)

Action group: Base actions

Description

Combining multiple actions into one named group.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Sequence ID

Action Sequence Identifier.

!! This parameter is not displayed and is assigned automatically by the system.

Action sequence identifier


Special conditions of use

None. 

Example of use

Task

There is an Excel file.

You need to open an Excel file, count the number of rows in it, close the file and log the number of rows in the file.

All actions related to Excel file processing should be grouped into one sequence.

Solution

  1. Add an Open action for the Excel document.
  2. Add the Get row number action.
  3. Add a Close action for the Excel document.
  4. Add a Message in log action.

Implementation

  1. Open the "Base Actions" action group.


  2. Place the "Actions group" action in the Studio workspace and rename it to "Work in Excel".


  3. Open the Excel action group.

  4. Place the "Open" action in the "Actions group" action loop and set its parameters (see description of the action "Open document (Word)").

    1. "Path to file" parameter. Specify the path to the Excel file to be opened.



  5. Place the "Get row number" action in the "Actions group" action loop and set its parameters (see the description of the action "Get row number Excel").

    1. "Context" parameter. Specify the context of the opened Excel file.


    2. "Column name" parameter. Specify the name of the column for which you want to get the number of rows.


    3. "Skip empty" parameter. Fill the checkbox so that only filled rows are counted.


  6. Place the "Close" action in the "Actions group" action loop and set its parameters (see description of the action "Close document (Word)").

    1. "Context" parameter. Specify the context of the opened Excel file.



  7. Open the "Base actions" action group.

  8. Place the "Message in log" action in the workspace and set its parameters (see the description of the action "Сообщение в лог / Log message").

    1. Parameter "Message". Specify the result of the "Get row number" action.



  9. Launch the robot using the "Start" button in the top panel. The final scheme of the robot will look as follows:

Result

The robot completed successfully.

Actions are grouped. 

The algorithm traverses all actions of the group and outputs the number of lines in the file to the log.

  • Нет меток