История страницы

...

1. Drag the following actions to the workspace:
   
   • «Open Browser», «Close Browser» from the «Browsers» action group;
   • «Open», «Save», «Close» from the «Excel» action group;
   • «For» from the «Basic Actions» group.

   Example:
   

2. Fill in the action parameters:
   

   1. Action «Open Browser» Open Browser action - choose «Chrome» from the drop-down list of browsers, and in the «Address» field, specify the link to the «Supplier Portal» website and navigate to the procurement plans tab. 

      Example:
      

   2. Action «Close Browser» Close Browser action - context browser.
      

   3. Action «Open» Open action - in the «File Path» parameter, specify the path to the Excel file.
      

   4. Actions «Save»  «Save» and «Close» actions - in the «Context» parameter, specify the previously opened Excel file.
      

   5. For action:

   • «From» - 1;
   • «To» - 5;
   • «Increment» - 1.
3. Analyze the XPath of the web element:
   Compare the XPath of two consecutive procurement plans for customer information and write them to a text file. It can be observed that the only difference between them is one digit.
   
4. Create a variable with the String data type and the value will be the XPath of the customer, where the changing digit will be replaced with the word «Customer».
   Example:
   
5. Fill the body of the loop with actions: «Convert Data» from the «Basic Actions» group, «Replace by Pattern» from the «Text» action group, «Get Text» from the «Browsers» action group, and «Set Cell Value» from the «Excel» action group.
   Example:
   
6. Fill in the action parameters:

...

To create a web element, follow these steps:

1. Select «Add the Add New Resource» Resource as the method of filling the parameter.
   

2. Fill in the Display Name parameter (with the "Element") and Default Attribute parameter by choosing «XPath» from the drop-down list.

3. Click the «Save» button.
   

4. In the Replace by Pattern action specify:

   • Parameter «Text» Text parameter - the previously created variable «Customer XPath»;

   • Parameter «Pattern» Pattern parameter - the word «CUSTOMER» to be replaced;

   • Parameter «Substitution» Substitution parameter - the result of the action «Convert Data».

   Parameter «Result» - XPath of the web element «Customer».
   
5. In the «Set Set Cell Value» Value action, specify:
   
   • Context parameter - the instance of the opened Excel file;
   • Row of the cell Cell parameter - use the expression builder tool to fill this parameter;
   • Value parameter - the result of the Get Text action
   

6. Start the robot.

7. The result of the robot’s work is a filled Excel file.