GetTable

The GetTable component enables extraction and display of data from Grids, List Box, Combo Box, HTML tables, and the count of Rows extracted from webpages and standard Windows controls.

Screenshot

Note

At present, the GetTable component is compatible with Internet Explorer and all Microsoft Windows native applications.

Ports

The GetTable component exposes Control In, Control Out and Data Out ports by default.

Port Description
Control In Must be connected to the Control Out port of one or more components.
Control Out Can be connected to the Control In port of any other component or connector.
Data Out (Count) Returns the extracted data count (Int32).
Data Out (Object) Returns the extracted data Object array (Object).

Properties

Property Description
Search Searchs for the respective property.
Delay After Execution Specifies the wait time (in seconds) after the Click actions is performed.
Delay Before Execution Specifies the wait time (in seconds) before the Click actions is performed.
Name Specifies the name to identify the component. Set the name to match the application field you are interacting with.
Click X Specifies the location of the GetTable action on the x-axis.
Click Y Specifies the location of the GetTable action on the y-axis.
Search As A Gray Scale Image Defines the selected area as a gray scale image.
Target Platform Allows users to select the aaplication platform.
Threshold Specifies the image matching accuracy before performing the click operation.Value of 1 defines 100% match, 0.5 defines 50% match; Defaults value is 0.9 or 90% match.
Max Wait Time in Seconds Defines the number of Seconds to wait for the image/application to appear on the screen. Default value is 30 Seconds.
Wait After Image Found Specifies the wait time (in seconds) after the image is found.
Wait For Create Define if the GetTable component must wait for the image to appear on the screen. Default value is True.

Example

Let us consider the example of extracting list from a Sample Application.

Screenshot

To extract the table:

  1. In the Toolbox, expand the Actions category.

  2. Drag the GetTable component and drop it on the design surface.

  3. Double click on the GetTable component to add multiple images. Screenshot

  4. To select the List to extract, click .Screenshot. Then Press “CTRL+SHIFT” for selection message is displayed.

  5. Press “CTRL+SHIFT”.The mouse pointer becomes a cross hair.

  6. If the First captured image is not displayed on the screen then it searches for next captured image. Click Screenshot sign to add next image.

  7. Select the webpage List to extract.The selected content is displayed in the GetTable component.

  8. To replace the selected content:

    • Right-click the content displayed in the GetTable component.

    • Select Capture Image.

    • Press “CTRL+SHIFT” and select the required content.
      The updated content is displayed in the GetTable component.

  9. To Copy the Extracted table to an Excel, Add an WriteToExcel component to the activity.

  10. To add the WriteToExcel component:

    • In the Toolbox, expand the Utilities.

    • Drag the WriteToExcel component and drop it on the design surface.

    • Define the FilePath.

    • Mention the SheetName.

  11. Connect:

    • The Control ports between Start and the GetTable component.

    • The Control Out port of the GetTable component with Control In port of the WriteToExcel component.

    • The Data Out port of the GetTable component with the Data In port of the WriteToExcel component.

    • The Control Out port of the WriteToExcel component with Control In port of the END component.

  12. Click Run.