1. Component description
Prerequisites: Start Excel or Get opened Excel
This component copies the content within a specified area.
2. Inputs
You can find help information for each input field in the component panel of the application flow editor.
3. Outputs
For more information about each output, see the component panel in the application flow editor.
4. Component example
4.1. Component configuration example
For
Opened Excel object, select v_excel_obj_1, which is the output of the prerequisite component (Start Excel or Get opened Excel).For
Sheet name, enter 'Sheet1'.For
Start row of area, enter '1'.For
Start column of area, enter 'A'.For
End row of area, enter '2'.For
End column of area, enter 'B'.Use the default values for advanced options.
4.2. Example result
None
5. Example of building a flow
Build the flow
Use the Start Excel component to start a specified Excel file.
Use the Copy Excel area component to copy the content from a specified area in the Excel file.
Use the Paste Excel area component to paste the copied content into a specified area on another sheet.
Result
As shown in the following figures, after the flow runs, it automatically opens the Excel file, copies the content of the A1:B2 area on Sheet1, and then pastes it into the area that starts from cell A2 on Sheet2.
