Represents individual worksheets in an Excel workbook (C1XLBook).
Namespace:
C1.Silverlight.ExcelAssembly: C1.Silverlight.Excel.5 (in C1.Silverlight.Excel.5.dll)
Syntax
C# |
---|
public class XLSheet : ICloneable |
Visual Basic |
---|
Public Class XLSheet _ Implements ICloneable |
Remarks
Provides indexers to get or set the value of individual cells (XLCell)
and to access the Rows and Columns on the sheet.
Examples
Use the C1XLBookSheets 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:
Copy CodeC#

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
C1.Silverlight.Excel..::..XLSheet