1. Introduction
Prerequisite components: Launch Excel or Get Opened Excel
Use this component to copy the content of cells in a specified column.
2. Inputs
For more information about each input, see the component's panel in the application flow editor.
3. Outputs
For more information about each output, see the component's panel in the application flow editor.
4. Component usage example
4.1. Configuration example
In
Opened Excel Object, select v_excel_obj_1, which is the output of a prerequisite component (Launch Excel or Get Opened Excel).Set Sheet Name to "Sheet1".
Set Column Number to "A".
Advanced option's default value
4.2. Example execution results
None
5. Sample flow
Setup flow
Use the Launch Excel component to open a specified Excel file.
Use the Copy Excel Column component to copy the content of cells in a specified column.
Use the Paste Excel Column component to paste the copied content into a specified column on another sheet.
Result
As shown in the figures below, after the flow runs, it automatically opens the Excel file, copies the content of the cells in column A of Sheet1, and then pastes that content into column B of Sheet2.