Insert Excel Row-Robotic Process Automation(RPA)-阿里云帮助中心

1. Component description

Note

Prerequisites: Start Excel or Get Opened Excel

This component inserts a row of empty cells before or after a specified row in an Excel sheet.

2. Inputs

Note

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

3. Outputs

Note

For information about the output parameters, see the component panel in the ROS Visual Editor.

4. Component usage example

4.1. Configuration example

Set Opened Sheet Object to v_Sheet_obj_1. This is the output from the Get Active Sheet or Activate Sheet component.
Set Target Row Number to "1".
Set Insertion Position to "Before target row number".
Default values for advanced options

4.2. Example result

None.

5. Flow creation example

Create the flow

Use the Start Excel component to open the specified Excel file.
Use the Get Active Sheet component to retrieve the active sheet object.
Use the Insert Excel Row component to insert a row of empty cells at the specified position in the Excel sheet.

Result

After the flow runs successfully, the Excel file is opened and a row of empty cells is inserted before the first row. The following figures show the result.