Edit this page
Available for: UI for ASP.NET AJAX | UI for ASP.NET MVC | UI for WPF | UI for WinForms | UI for Silverlight

Add and Remove Worksheets

This article demonstrates how to add and remove worksheets from a workbook.

Add Worksheets

Adding a new worksheet to a workbook can be easily achieved through its Worksheets collection. The collection exposes an Add() method that does not take arguments and returns the instance of the newly created worksheet. By default worksheets are assigned the first available name in the sequence Sheet1, Sheet2, Sheet3… You can easily change the name of the worksheet through the Worksheet.Name property. More information about renaming a worksheet is available in the Rename a Worksheet article.

Example 1 creates a workbook from scratch and adds a single worksheet to it. Since this is the first worksheet in the workbook, it is also set as the active worksheet. All worksheets added after it will not become active.

[C#] Example 1: Create a workbook and add a worksheet to it

Workbook workbook = new Workbook();
Worksheet newWorksheet = workbook.Worksheets.Add();

Remove Worksheets

The Worksheets collection of the workbook offers two methods for removing worksheets: Remove() and RemoveAt(). The former method requires the worksheet name or the worksheet instance to be passed as an argument. The latter allows you specify the index of the worksheet you would like to remove.

Example 2 creates a workbook and adds four worksheets. All worksheets are with their default names: Sheet1, Sheet2, Sheet3 and Sheet4. The code further demonstrates how to remove three worksheets using all of the aforementioned remove methods.

[C#] Example 2: Add and remove worksheets

Workbook workbook = new Workbook();
workbook.Worksheets.Add(); // Sheet1
Worksheet secondWorksheet = workbook.Worksheets.Add(); // Sheet2
workbook.Worksheets.Add(); // Sheet3
workbook.Worksheets.Add(); // Sheet4

workbook.Worksheets.RemoveAt(3); // Removed Sheet4
workbook.Worksheets.Remove("Sheet1"); // Removed Sheet1
workbook.Worksheets.Remove(secondWorksheet); // Removed Sheet2
// the only worksheet left is Sheet3