ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLSheetCollection Class
Properties Methods

In This Topic
    XLSheetCollection Class Members
    In This Topic

    The following tables list the members exposed by XLSheetCollection.

    Public Properties
     NameDescription
    Public PropertyBookGets a reference to the C1XLBook that owns the collection.  
    Public PropertyCountGets the number of XLSheet objects in the collection.  
    Public PropertyFirstIndexGets or sets the index of the sheet that is initially opened when a C1XLBook file is loaded into Excel.  
    Public PropertyItemOverloaded. Gets the XLSheet at a given position in the collection.  
    Public PropertySelectedIndexGets or sets the index of the sheet that is selected when a C1XLBook file is loaded into Excel.  
    Public PropertySelectedIndexesGets or sets the index array of the sheets that is selected when a C1XLBook file is loaded into Excel.  
    Top
    Public Methods
     NameDescription
    Public MethodAddOverloaded. Creates a new XLSheet and appends it to the collection.  
    Public MethodClearRemoves all items from the collection.  
    Public MethodContainsOverloaded. Determines whether the collection contains a specific XLSheet object.  
    Public MethodIndexOfOverloaded. Gets the index of a given XLSheet in the collection.  
    Public MethodInsertOverloaded. Creates a new XLSheet and inserts it at a specific position in the collection.  
    Public MethodRemoveOverloaded. Removes an XLSheet from the collection.  
    Public MethodRemoveAtRemoves the XLSheet at a specific index from the collection.  
    Top
    See Also

    Reference

    XLSheetCollection Class
    C1.Excel Namespace