DocsICP FilingConsole
官方文档
首页

Copy sheet

更新时间：
复制 MD 格式
产品详情
我的收藏

1. Component introduction

Note

Prerequisites: Launch Excel or Get Opened Excel

This component copies a specified sheet in an Excel file to a new sheet.

2. Inputs

Note

For details about each input, see the component panel of the application flow editor.

3. Outputs

Note

For details about each output, see the component panel of the application flow editor.

4. Component usage example

4.1. Component configuration example

  1. For Opened Excel object, select the v_excel_obj_1 object returned by the Launch Excel or Get Opened Excel component.

  2. Set Name of the sheet to copy to the name of the sheet you want to copy, such as "Sheet1".

  3. Set Copy method to "Copy to another Excel file".

  4. Set Target Excel object to `v_excel_obj_2`, which is the output of the Launch Excel or Get Opened Excel component.

  5. Set New sheet name to the name of the destination sheet, such as "Test Copy Sheet".

  6. Keep the default values for the advanced options.

4.2. Example execution result

None

5. Flow creation example

Setup flow

  1. Use the Launch Excel component to open Excel File 1.

  2. Use the Get Sheet Names component to retrieve the names of all sheets in File 1.

  3. Use the Launch Excel component to open Excel File 2.

  4. Use the Copy Sheet component to copy the specified sheet from File 1 to a new sheet in File 2.

Execution result

After the flow is executed, the content of the specified sheet is copied to the new sheet, as shown in the following figure.

image

Previous：Create a sheetNext：Delete a sheet