Create a sheet-Robotic Process Automation(RPA)-阿里云帮助中心

1. Introduction

Note

Prerequisites: Start Excel or Get opened Excel

This component creates a new sheet.

2. Inputs

Note

For more information about each input, see the help text in the component panel of the visual editor.

3. Outputs

Note

For more information about each output, see the help text in the component panel of the visual editor.

4. Component Usage Example

4.1. Sample configuration

For Opened Excel object, select v_excel_obj_1, which is the output of the Start Excel or Get opened Excel component.
For Sheet name, enter "Test new sheet".
For Sheet position, select "First".
Default Values for Advanced Options

4.2. Sample result

None

5. Sample flow

Setup flow

Use the Get opened Excel component to retrieve the opened Excel file object.
Use the Create sheet component to create a new sheet.
Use the Write a row to the end of Excel component to write ["Xiong Er", "18"] to the last row of the specified sheet.
Use the Save Excel component to save the Excel file.

Result

After the flow runs, it retrieves the opened Excel file, creates a new sheet, writes the specified content to the first row, and saves the file. The result is shown in the following figure.