Example of entering data into a web form from a worksheet

In this example, you build a Bot to enter multiple rows of data from an XLSX sheet into a web form. Use アクション from the Excel の高度な操作, ループ, and レコーダー パッケージ.

前提条件

Before you start building the Bot, you can create the following data sets on your desktop in .xlsx format as below.
Employee name Age Claim amount Claim date Claim type
Mike 30 469 22/3/2022 Medical
Sarah 34 766 28/3/2022 Dental
Chris 41 428 13/05/2022 Medical
Samantha 45 1000 09/05/2022 Medical
To retrieve values from an Excel file and input them into a web form, do the following:

手順

  1. 新規 Botを作成します。
    1. 左側のペインで [オートメーション] をクリックします。
    2. [新規作成] > [Bot] をクリックします。
    3. [タスク Bot を作成] ウィンドウで、Bot名を入力します。
    4. 次のデフォルトのフォルダーの場所をそのまま使用します。\Bots\
      デフォルトのBotの保存場所を変更するには、[選択] をクリックしてプロンプトに従います。
    5. [作成と編集] をクリックします。
  2. Open the Excel file.
    1. Double-click or drag the Excel advanced > Open action.
    2. Enter a session name.
    3. Select the Excel file.
    4. Mark the Sheet contains a header option.
    By marking the Sheet contains a header option, you enable the Bot to search for the column by the header name during run time.
  3. Launch the website.
    1. Double-click or drag the Browser > Open アクション.
    2. Enter the website URL which consists the webform to update the data.
  4. Retrieve the worksheet values and store them in a Table variable.
    1. Double-click or drag the Excel advanced > Get multiple cells action.
    2. Enter the same session name you used in the Excel advanced > Open action.
    3. Select All rows from the drop-down list.
    4. Create a Table variable using the icon to the right of the Assign to variable drop-down list.
  5. Instruct the Bot to process the data row by row.
    1. Double-click or drag the Loop action.
    2. Select the For each row in table iterator.
    3. Select the same Table variable that you used in Get multiple cells.
    4. Create a Record variable using the icon to the right of the Assign to variable drop-down list.
    The Record variable holds all of the values for one row. With each iteration of the Loop, the Bot retrieves the values of the next row and stores them in the Record variable, overwriting the values from the previous row.
  6. Map the first column header to the web form textbox.
    1. Double-click or drag the Recorder > Capture action.
    2. Select the same window you opened with the Open アクション.
    3. Click Capture object.
    4. Hover over the textbox until a red outline appears.
    5. Click the textbox.
    6. Return to the Control Room.
    7. Verify that the Control Type value is TEXTBOX.
    8. Select Set text from the Action drop-down list.
    9. In the Keystrokes field, insert the same Record variable that you used in the Loop.
    10. Select the By name option and copy-paste the first column header into the field.
  7. Repeat the sub-steps in step 5 to map the other columns, with the following differences:
    1. Instead of searching for the browser window title, insert the Window variable generated by the Recorder.
    2. When inserting the Record variable in the Keystrokes field, copy-paste the subsequent column header into the "By name" field.
  8. Capture the Submit button.
    1. Double-click or drag the Recorder > Capture action.
    2. Insert the Window variable generated by the Recorder.
    3. Click Capture object.
    4. Verify that the Control Type value is BUTTON.
    5. Select the Click action.
  9. Click Save.