WorksheetCollection Class

public class WorksheetCollection : CollectionBase

Public Class WorksheetCollection
	Inherits CollectionBase

public ref class WorksheetCollection : public CollectionBase

type WorksheetCollection =  
    class
        inherit CollectionBase
    end

[C#]

Workbook workbook = new Workbook();

WorksheetCollection sheets = workbook.Worksheets;

//Add a worksheet
sheets.Add();

//Change the name of a worksheet
sheets[0].Name = "First Sheet";

//Set the active sheet to the second worksheet
sheets.SetActiveSheet(1);


[Visual Basic]

Dim excel as Workbook = new Workbook()

Dim sheets as WorksheetCollection = excel.Worksheets

'Add a worksheet
sheets.Add()

'Change the name of a worksheet
sheets(0).Name = "First Sheet"

'Set the active sheet to the second worksheet
sheets.SetActiveSheet(1)