Rename a sheet

更新时间:
复制 MD 格式

1. Component introduction

Note

Prerequisites: Launch Excel or Get Opened Excel

This component renames a specified sheet.

2. Inputs

Note

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

3. Outputs

Note

For information about each output, 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. This object is the output of a prerequisite component, such as Launch Excel or Get Opened Excel.

  2. For Old sheet name, enter "Sheet1".

  3. For New sheet name, enter "New Sheet".

  4. Keep the default values for the advanced options.

4.2. Example execution result

None

5. Example of building a flow

Configuration Flow

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

  2. Use the Activate Sheet component to activate a sheet by name.

  3. Use the Rename Sheet component to rename "Sheet1" to "New Sheet".

  4. Use the Save Excel component to save the Excel file.

Execution result

After the flow runs, it opens the specified Excel file, activates the specified sheet, renames the sheet, and saves the file.