Copy Excel row-Robotic Process Automation(RPA)-阿里云帮助中心

1. Component introduction

Note

Prerequisite components: Start Excel or Get Opened Excel

You can use this component to copy the content of cells in a specified row.

2. Input items

Note

For more information about each input parameter, see the help text in the component panel of the ROS Visual Editor.

3. Output items

Note

For more information about each output parameter, see the help text in the component panel of the ROS Visual 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 Start Excel or Get Opened Excel component.
Set Sheet name to "Sheet1".
Set Row number to "1".
Use the default values for the 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 content of the cells in a specific row of the Excel file.
Use the Paste Excel row component to paste the copied content into a specific row in another sheet.

Execution result

As shown in the following figures, the flow opens the Excel file, copies the content of the cells in the first row of Sheet1, and pastes the content into the second row of Sheet2.