Method: RemoveAll for Worksheets

Method: RemoveAll for Worksheets

Deletes all worksheets of an Excel workbook.

Object.RemoveAll

The following example creates an Excel workbook, deletes all the worksheets, and creates a new worksheet named Data. Refer to the help page Worksheets for detailed examples:

Dim oMyWorkbook, oMyWorkSheet
Set oMyWorkbook = CreateExcelWorkbook()
Call  oMyWorkbook.Worksheets.RemoveAll
Set oMyWorkSheet = oMyWorkbook.Worksheets.Add("Data")

oMyWorkbook = dd.CreateExcelWorkbook() 
 oMyWorkbook.Worksheets.RemoveAll() 
oMyWorkSheet = oMyWorkbook.Worksheets.Add("Data")