Get Excel column values-Robotic Process Automation(RPA)-阿里云帮助中心

1. Introduction

Note

Prerequisites: Start Excel or Get Opened Excel

This component retrieves the content of cells from a specified Excel column.

2. Inputs

Note

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

3. Outputs

Note

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

4. Component usage example

4.1. Configuration example

Set Opened Sheet Object to v_Sheet_obj_1, which is the output of the Get Active Sheet or Activate Sheet component.
Set Column Number to "A".
For Maximum Rows, use the default value of "5000".
Default values for advanced options

4.2. Result

None.

5. Sample flow

Setup flow

Use the Start Excel component to open the specified Excel file.
Use the Get Active Sheet component to obtain the active sheet object.
Use the Get Excel Column Values component to retrieve the cell values from the specified column.
Use the Record Log component to print the specified content.

Result

The flow opens the Excel file, retrieves the cell content from a specific column, and then prints the content. The results are shown in the following figures.