1. Introduction
Prerequisites: Launch Excel or Get Opened Excel
You can use this component to paste copied content into a specified cell area.
2. Inputs
For more information about each input, see the help text in the component panel of the visual editor.
3. Outputs
For more information about each output, see the help text in the component panel of the visual editor.
4. Component example
4.1. Configuration example
For
Opened Excel Object, select v_excel_obj_1. This is the output of the preceding Launch Excel or Get Opened Excel component.For
Sheet Name, enter "Sheet2".For
Cell Row Number, enter "2".For
Cell Column Letter, enter "A".For Paste Special As, keep the default selection,
All.Advanced option defaults
4.2. Example result
None.
5. Example flow
Setup Flow
You can use the Launch Excel component to open a specific Excel file.
You can use the Copy Excel Area component to copy the content of cells in a specified area of the Excel file.
You can use the Paste Excel Area component to paste the copied content to a specific cell area in another sheet.
Result
As shown in the following figure, after the flow is executed successfully, it automatically opens an Excel file, copies the content from cells A1:B2 on Sheet1, and pastes it into Sheet2 starting at cell A2.
