ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLSheet Class
Members Example

In This Topic
    XLSheet Class
    In This Topic
    Represents individual worksheets in an Excel workbook (C1XLBook).
    Object Model
    XLSheet Class
    Syntax
    'Declaration
     
    Public Class XLSheet 
    public class XLSheet 
    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 C1XLBookC1XLBook.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.Excel.XLSheet

    See Also