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.Xaml.Excel.XLSheet

Reference

XLSheet Members
C1.Xaml.Excel Namespace