1. Component introduction
Prerequisite components: Start Excel or Get Opened Excel
Use this component to retrieve the name of the current sheet or the names of all sheets in an Excel file.
2. Inputs
For more information about the input parameters, see the component panel in the ROS Visual Editor.
3. Outputs
For help with each output item, see the component panel in the Visual Editor.
4. Component usage examples
4.1. Component configuration example
Set
Opened Excel Objectto `v_excel_obj_1`. This is the output of the preceding Start Excel or Get Opened Excel component.Set
Get Scopeto "All Sheets".Keep the default values for the advanced options.
4.2. Example execution result
None
5. Flow creation example
Setup flow
Use the Start Excel component to open Excel file 1.
Use the Get Sheet Names component to retrieve the names of all sheets in file 1.
Use the Start Excel component to open Excel file 2.
Use the Copy Sheet component to copy a specified sheet from file 1 to a new sheet in file 2.
Result
After the flow runs, the content of the specified sheet is copied to a new sheet, as shown in the following figure.
