1. Component introduction
Prerequisites: Start Excel or Get Opened Excel
Use this component to retrieve the content of cells in a specified area.
2. Inputs
For information about each input, see the component panel in the application flow editor.
3. Outputs
For information about each output, see the component panel in the application flow editor.
4. Component usage example
4.1. Configuration example
For
Opened Sheet Object, select v_Sheet_obj_1, which is the output of a prerequisite component such as Get Active Sheet or Activate Sheet.Set
Start Row Number of Areato 1.Set
Start Column Letter of Areato A.Set
End Row Number of Areato 6.Set
End Column Letter of Areato B.For
Maximum Rows to Get, the default value is 5000.Advanced option defaults
4.2. Example result
None
5. Example flow
Create the flow
Use the Start Excel component to start a specified Excel file.
Use the Get Active Sheet component to retrieve the active sheet object.
Use the Get Values from Excel Area component to retrieve the values of cells in a specified area.
Use the Record Log component to print the specified content.
Result
As shown in the following figures, after the flow runs successfully, it automatically opens the Excel file, retrieves the content of the cells in the specified Excel area, and prints the content.