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

1. Introduction

Note

Prerequisites: The Launch Excel or Get Opened Excel component must run before this component.

This component automatically closes an Excel file.

2. Inputs

Note

For information about the input parameters, see the component's help information in the application flow editor.

3. Outputs

Note

For information about the output parameters, see the component's help information in the application flow editor.

4. Component usage example

4.1. Component configuration example

For Opened Excel object, select the output `v_excel_obj_1` from a preceding component, such as Launch Excel or Get Opened Excel.
Set Save on close to Yes.
Defaults for advanced options

4.2. Example execution results

None

5. Example flow

Setup flow

Use the Get Opened Excel component to retrieve the object of an opened Excel file.
Use the Get Active Sheet component to retrieve the active sheet object.
Use the Write Line to 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.
Use the Close Excel component to close the Excel file.

Execution result

After the flow runs, it retrieves the opened Excel file, writes the specified values to the last row, and then saves and closes the file. The following figure shows the result.