1. Component introduction
Prerequisites: Start Excel or Get Opened Excel
Use this component to activate a specified sheet.
2. Inputs
For information about the input parameters, see the component panel in the application flow editor.
3. Outputs
For information about the output parameters, see the component panel in the application flow editor.
4. Component usage example
4.1. Component configuration example
For Opened Excel object, select
v_excel_obj_1, which is an output from the Start Excel or Get Opened Excel component.For
Sheet name, enter "Sheet1".Default values for advanced options
4.2. Example result
None
5. Flow creation example
Create the flow
Use the Start Excel component to open a specified Excel file.
Use the Activate sheet component to activate a sheet by its name.
Use the Rename sheet component to rename "Sheet1" to "New Sheet".
Use the Save Excel component to save the Excel file.
Execution result
When the flow runs, it opens the specified Excel file, activates the specified sheet, renames the sheet, and saves the file.