Paste an Excel row
1. Component introduction
Prerequisites: Start Excel or Get Opened Excel
You can use this component to paste copied content into the cells of a specified row.
2. Inputs
For more information about each input field, see the help text in the component panel of the Visual Editor.
3. Outputs
For details about the output parameters, see the component panel in the application flow editor.
4. Component usage example
4.1. Component configuration example
For
Excel Object, select v_excel_obj_1, which is the output from the Start Excel or Get Opened Excel component.Enter "Sheet2" in the
Sheet namefield.For
Row Number, enter "2".For
Paste Special As, use the default value `All`.Defaults for advanced options
4.2. Example execution result
None
5. Flow creation example
Setup flow
Use the Start Excel component to open a specific Excel file.
Use the Copy Excel Row component to copy the contents of a specific row in the Excel file.
Use the Paste Excel Row component to paste the copied content into a specific row on another sheet.
Execution result
After the flow runs, it opens the Excel file, copies the content of the first row from Sheet1, and pastes it into the second row on Sheet2. The following figures show the result.