1. Component introduction
Prerequisites: Launch Excel or Get Opened Excel
Use this component to copy the content of a specified cell in an Excel file.
2. Inputs
For more information about the input parameters, see the component panel in the application flow editor.
3. Outputs
For more information about the output parameters, see the component panel in the application flow editor.
4. Component usage example
4.1. Component configuration example
For
Opened Excel Object, select v_excel_obj_1, which is the output of the Launch Excel or Get Opened Excel component.Set
Sheet Nameto "Sheet1".Set
Cell Row Numberto "1".Set
Cell Columnto "A".Keep the default values for the advanced options.
4.2. Example execution result
None.
5. Flow creation example
Setup process
Use the Launch Excel component to open a specified Excel file.
Use the Copy Excel Cell component to copy the content of a cell at a specified location.
Use the Paste Excel Cell component to paste the copied content into a cell on another sheet.
Execution result
The flow automatically opens the Excel file, copies the content of cell A1 on Sheet1, and then pastes it into cell A2 on Sheet2.