Delete sheet

1、 Video example

To be launched.

 

2、 Function description

Delete a specified sheet in the excel file.

 

3、 Attribute description

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

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

 

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”。 Then delete the file named & ldquo; sheet1” Table for.

2. Output results