XLSheet Class

Represents individual worksheets in an Excel workbook (C1XLBook).

Object Model

Syntax

Visual Basic
C#

'Declaration
 
Public Class XLSheet 
   Implements ICloneable

public class XLSheet : ICloneable

Remarks

Provides indexers to get or set the value of individual cells (XLCell) and to access the Rows and Columns on the sheet.

Example

Use the C1XLBook C1XLBook.Sheets indexer to get an individual sheet. For example, the code below gets a reference to the first sheet on the book, then prints the number of rows and columns on the sheet:

C1XLBook book = new C1XLBook();
XLSheet sheet = book.Sheets[0];
Debug.WriteLine("Sheet has {0} rows and {1} columns",
  sheet.Rows.Count, sheet.Columns.Count);

Inheritance Hierarchy

System.Object
C1.Silverlight.Excel.XLSheet

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

XLSheet Members
C1.Silverlight.Excel Namespace