Get the value of an Excel cell-Robotic Process Automation(RPA)-阿里云帮助中心

1. Introduction

Note

Prerequisites: Start Excel or Get opened Excel

This component retrieves the value of a specified cell.

2. Inputs

Note

For help with each input item, see the component panel in the visual editor.

3. Outputs

Note

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

4. Component usage example

4.1. Component configuration

For Opened Sheet object, select v_Sheet_obj_1. This is the output of the Get active sheet or Activate sheet component.
Set Cell row number to "1".
Set Cell column number to "A".
Defaults for advanced options

4.2. Example result

None.

5. Sample flow

Create the flow

Use the Start Excel component to open a specific Excel file.
Use the Get active sheet component to obtain the object of the active sheet.
Use the Get value of Excel cell component to retrieve the value of a specific cell.
Use the Record log component to print the value.

Result

As shown in the following figure, after the flow executes successfully, it automatically opens an Excel file, retrieves the content of a specified cell, and prints the content.