Adding Worksheets to a Workbook

The ExcelWorkbook class offers access to its collection of worksheets using the Worksheets property. By default, when a workbook is created, its Worksheets collection contains a single worksheet. More worksheets can be added to the collection using the AddWorksheet(String) method. You can add a worksheet with the default name or you can specify the name of the new worksheet as parameter.

Code Samples

Below there is a sample code that show how to add a second worksheet with the name 'Simple Chart' to the workbook:

Copy

ExcelWorksheet secondWorksheet = workbook.Worksheets.AddWorksheet("Simple Chart");

Dim secondWorksheet As ExcelWorksheet = workbook.Worksheets.AddWorksheet("Simple Chart")

A reference to a worksheet from the current workbook can be obtained using one of the two index properties of the ExcelWorksheetsCollection. The first one returns the worksheet at the specified zero based index and the second one returns the worksheet with the specified name:

Copy

ExcelWorksheet secondWorksheet = workbook.Worksheets[1];
ExcelWorksheet secondWorksheet = workbook.Worksheets["Simple Chart"];

Dim secondWorksheet As ExcelWorksheet = workbook.Worksheets(1)
Dim secondWorksheet As ExcelWorksheet = workbook.Worksheets("Simple Chart")