XLSheetCollection Class

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

Object Model

Syntax

Visual Basic
C#

'Declaration
 
<System.Reflection.DefaultMemberAttribute("Item")>
Public Class XLSheetCollection

[System.Reflection.DefaultMember("Item")]
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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

XLSheetCollection Members
C1.WPF.Excel Namespace