XLSheetCollection Class

In This Topic

Collection of XLSheet objects that represent the individual worksheets in a C1XLBook.

Object Model

Syntax

Visual Basic
C#

'Declaration
 
Public Class XLSheetCollection

public class XLSheetCollection

Remarks

Provides methods and properties for counting, enumerating, adding, and removing sheets from the workbook.

Example

Use the C1XLBook C1XLBook.Sheets property to get the book's sheet collection. For example, the code below gets a reference to the first sheet on the book and then prints the sheet's name:

C1XLBook book = new C1XLBook();
XLSheet sheet = book.Sheets[0];
Debug.WriteLine(sheet.Name);

Inheritance Hierarchy

System.Object
C1.WPF.Excel.XLSheetCollection

Reference

XLSheetCollection Members
C1.WPF.Excel Namespace