Copy an Excel cell

更新时间:
复制 MD 格式

1. Component introduction

Note

Prerequisites: Launch Excel or Get Opened Excel

Use this component to copy the content of a specified cell in an Excel file.

2. Inputs

Note

For more information about the input parameters, see the component panel in the application flow editor.

3. Outputs

Note

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

  1. For Opened Excel Object, select v_excel_obj_1, which is the output of the Launch Excel or Get Opened Excel component.

  2. Set Sheet Name to "Sheet1".

  3. Set Cell Row Number to "1".

  4. Set Cell Column to "A".

  5. Keep the default values for the advanced options.

4.2. Example execution result

None.

5. Flow creation example

Setup process

  1. Use the Launch Excel component to open a specified Excel file.

  2. Use the Copy Excel Cell component to copy the content of a cell at a specified location.

  3. 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.