Get the current active sheet

更新时间:
复制 MD 格式

1. Introduction

Note

Prerequisites: Launch Excel or Get Opened Excel

This component retrieves the current active sheet.

2. Inputs

Note

For help with each input item, see the component panel of the visual editor.

3. Outputs

Note

For more information about the outputs, see the component panel in the application flow editor.

4. Component Usage Example

4.1. Component configuration example

  1. Set Opened Excel Object to v_excel_obj_1, which is the output parameter of the Launch Excel or Get Opened Excel component.

4.2. Example execution result

None.

5. Example flow

Setup flow

  1. Use the Launch Excel component to open an Excel file.

  2. Use the Get Active Sheet component to retrieve the active sheet object.

  3. Use the Insert Image into Excel component to insert an image into the sheet.

    image

Result

After the flow runs, the specified image is inserted into the specified sheet in the Excel file, as shown in the following figure.