订阅

UiPath 活动

UiPath 活动指南

提取表格数据

📘

Note:

The Object Repository does not currently support this activity.

UiPath.UIAutomationNext.Activities.NExtractData

描述

Extracts data from a specified web page or application. Use this activity to extract structured information such as table data or web search results that can span multiple pages. Follow the Extract Wizard to indicate what information to extract. This activity must be added inside a Use Application/Browser activity. To find out more about the way the wizard included in this activity, view the Table Extraction page.

属性

Common

  • Continue on error - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
  • Delay after - Delay (in seconds) between the time this activity is completed and the time the next activity begins any operations. The default value is 0.3 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • Delay before - Delay (in seconds) between the time the previous activity is completed and the time this activity begins performing any operations. The default value is 0.2 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • DisplayName - The name displayed for the activity in the Designer panel.
  • Timeout - Specify a number of seconds for which to wait for the activity to be executed before throwing an error. The default value is 30 seconds.

Input

  • ExtractMetadata - An XML string that enables you to define what data to extract from the indicated web page.
  • Target - Before indicating on screen the application you want to automate, this field is set to (null). Once the target is indicated, all properties regarding the element that was indicated are displayed.
    • Target.Fuzzy selector - The parameters for the fuzzy selector.
    • Target.Native text - The text that is used to identify the target element.
    • Target.Selector - The selector that is generated for the indicated element.
    • Target.Targeting methods - The selector types that you want to use for identifying the element. This property can be set to any combination of Selector, Fuzzy selector, or Image.
    • Target.Wait for page load - Before performing the action, wait for the application to become ready to accept input. The following options are available:
      • None - Does not wait for the target to be ready.
      • Interactive - Waits until only a part of the app is loaded.
      • Complete - waits for the entire app to be loaded.
    • Target.Window selector (Application instance) - The selector that is used for the application window. Only applicable when the window attach mode is set to Application instance.
  • Target (Next button) - The target of the second indicated button, based on which the table is extracted. Just like the Target property, before indicating on screen the application you want to automate, this field is set to (null). Once the target is indicated, all properties regarding the element that was indicated are displayed. Contains the same fields as the Target property.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

选项

  • Append results - Specifies whether the results are appended after the already existing values, if applicable, or the entire information is overwritten.
  • “数据表”- 从指定网页中提取的信息。该字段仅支持“数据表”变量。
  • Delay between pages - The amount of time (in seconds) to wait until the next page is loaded. The default value is 0.3 seconds. If the loading time of the page is longer, this value should be higher.
  • Input mode - Select how to execute the click on the next page link if the data spans multiple pages:
    • Same as App/Browser - Use the same input mode as the Use Application/Browser activity. This is the default selection.
    • Edge Chromium API - Performs actions using debugger APIs. Works for Edge Chromium elements only. Sends all text in one go. Works even if the target application is not in focus.
    • Window Messages - Sends a specific message to the target application. This input method can work in the background, is compatible with most desktop apps, but it is not the fastest of the methods.
    • Hardware Events - Simulates the click by using the hardware driver. This is the slowest method, it cannot work in the background, but it is compatible with all desktop apps.
    • Simulate - Simulates the click using the technology of the target application. This input method is the fastest and works in the background.
  • Limit extraction to - Specifies the type of limit that you want to use when extracting data. This property works alongside the Number of items property. The following options are available: Max Rows, No Limit, and Max Pages.
  • Number of items - The maximum number of results to be extracted. If the value is 0, all the identified elements are added to the output. This property works alongside the Limit extraction to property. The default value is 100.

UiPath.UIAutomationNext.Activities.NExtractData

描述

Extracts data from a specified web page or application. Use this activity to extract structured information such as table data or web search results that can span multiple pages. Follow the Extract Wizard to indicate what information to extract. This activity must be added inside a Use Application/Browser activity.

To learn how to use this activity, see Tutorial: Extracting Table Data from a Web Page and Editing It in Excel.

配置活动

In the Body of the Activity

  • Click Indicate target on screen to indicate the data to extract by following the Extract Wizard.
  • Extract to - Click Plus plus button on the right side of the field and then, from the menu, select what to do with the extracted data:
    • Select an Excel file and then a sheet, named range, or table where to copy the data. Alternatively you can click Indicate in Excel to select directly from the file.
    • Save for Later Use - Use the data later in your project as input for another activity.
    • Open in Advanced Editor - Enter a VB expression.
  • After you indicate the target, click Menu Options button to access the following options:
    • Indicate target on screen - Indicate the target again.
    • Configure Next Link - Configure the link to click for moving to the next page if the data spans multiple pages.
    • Test Extraction - Run a test of the data extraction with the current configuration. The result is displayed in the Preview Data window.

In the Properties Panel

Common

  • Continue on error - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
  • Delay after - Delay (in seconds) between the time this activity is completed and the time the next activity begins any operations. The default value is 0.3 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • Delay before - Delay (in seconds) between the time the previous activity is completed and the time this activity begins performing any operations. The default value is 0.2 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • DisplayName - The name displayed for the activity in the Designer panel.
  • Timeout - Specify a number of seconds for which to wait for the activity to be executed before throwing an error. The default value is 30 seconds.

Input

  • ExtractMetadata - An XML string that enables you to define what data to extract from the indicated web page.

Misc

  • Private - If selected, the data used by the activity is not saved to the StudioX logs when the project is executed.

选项

  • DataTable - See Extract to in the body of the activity.
  • Delay between pages - The amount of time (in seconds) to wait until the next page is loaded. The default value is 0.3 seconds. If the loading time of the page is longer, this value should be higher.
  • Input mode - Select how to execute the click on the next page link if the data spans multiple pages:
    • Same as App/Browser - Use the same input mode as the Use Application/Browser activity. This is the default selection.
    • Window Messages - Sends a specific message to the target application. This input method can work in the background, is compatible with most desktop apps, but it is not the fastest of the methods.
    • Hardware Events - Simulates the click by using the hardware driver. This is the slowest method, it cannot work in the background, but it is compatible with all desktop apps.
    • Simulate - Simulates the click using the technology of the target application. This input method is the fastest and works in the background.
  • Maximum results - The maximum number of results to be extracted. If the value is 0, all the identified elements are added to the output. The default value is 100.

Updated about a month ago


提取表格数据


建议的编辑仅限用于 API 参考页面

You can only suggest edits to Markdown body content, but not to the API spec.