Get table content (web)

Updated at:

1. Introduction

Note

Prerequisites: The Open new web page or Get opened web page component.

This component supports only web page tables that use the `table` tag. Note: To check if a table uses this tag, press the F12 keyboard shortcut to open the developer tools.

Use this component to retrieve table content from a page in a Chrome, Edge, or IE browser object and write the content to an Excel file.

2. Inputs

Note

For details about each input, refer to the help information in the component panel of the visual editor.

3. Outputs

Note

For more information about each input field, see the help text in the component panel of the application flow editor.

4. Component usage example

4.1. Configuration example

  1. Set Opened browser object to v_web_obj_1, the output of the prerequisite component (Open new web page or Get opened web page).

  2. Set Browser type to Chrome.

  3. Keep the default values for the other options.

4.2. Example result

The component successfully retrieves the content of the first table (ordinal number 1) from the specified page in Chrome and writes the content to an Excel file.

5. Example flow

Setup flow

  1. Use the Open new web page component to open a Chrome browser and navigate to the Alibaba Cloud RPA Product Billing page.

  2. Use the Get table content (web) component to retrieve the content of the first table in the Chrome browser.

  3. Use the Get opened Excel component to obtain the Excel object.

  4. Use the Activate sheet component to activate the target sheet.

  5. Use the Write to Excel range component to write the retrieved table content to a specified area in the sheet.

image..png

Result

As shown in the following figure, the component successfully retrieves the table content from the specified website and writes it to an Excel file.