Find Excel cell-Robotic Process Automation(RPA)-阿里云帮助中心

1. Component introduction

Note

Prerequisite components: Start Excel or Get Opened Excel

Use this component to find the location of a cell based on its content.

2. Input parameters

Note

For information about the input parameters, see the help text for each parameter in the component panel of the ROS Visual Editor.

3. Output parameters

Note

For information about the output parameters, see the help text for each parameter in the component panel of the ROS Visual Editor.

4. Component usage example

4.1. Component configuration example

For Opened Sheet Object, select v_Sheet_obj_1, which is the output of the Get Active Sheet or Activate Sheet component.
Set Area Start Row Number to 1.
Set Area Start Column Letter to A.
Set Area End Row Number to 7.
Set Area End Column Letter to C.
Set Value to Find to "Test".
Use the default values for the advanced options.

4.2. Example execution result

None

5. Example of building a flow

Setup flow

Use the Start Excel component to start the specified Excel file.
Use the Get Active Sheet component to obtain the active sheet object.
Use the Find Excel Cell component to find the cell that contains "Test" in the specified area and return the cell location.
Use the Log Record component to print the returned cell location information.

Execution result

As shown in the figures below, after the flow runs, it opens the Excel file, finds the cell that contains "Test" in the specified area, and prints the location of the cell.