Copy sheet

1、 Video example

To be launched.

 

2、 Function description

Copy a sheet from an excel file.

 

3、 Attribute description

● workbook objects: an excel file workbook variable that is already open.

● copy sheet name: name of the worksheet to copy: for example, "Sheet1" means to copy the "Sheet1" table.

● new table name: the name of the copied sheet.

● is it saved: whether to save the file after copying.

 

4、 Use example

1. Execution logic

Open an excel named & ldquo; sheet1” Make a copy of the table and name the copied table & ldquo; newName”。

2. Output results