Xceed Workbooks for .NET v1.4 Documentation
WorksheetCollection Class Members
Properties  Methods 


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace : WorksheetCollection Class

The following tables list the members exposed by WorksheetCollection.

Public Properties
 NameDescription
Public PropertyGets the number of Worksheet in the WorksheetCollection. The default is one Worksheet per Workbook.  
Public PropertyOverloaded. 

Gets the Worksheet element that is located at the specified Id.

The first worksheet starts at 0.

 
Top
Public Methods
 NameDescription
Public MethodOverloaded. This method allows to add a Worksheet to the WorksheetCollection.  
Public MethodReturns true if the WorksheetCollection contains a Worksheet with the name “worksheetName”; returns false otherwise.  
Public MethodOverloaded. This method is used to create a copy of a specific worksheet. The worksheet to be copied can be specified by its index, name or by using the Worksheet object itself.  
Public Method  
Public MethodOverloaded. Adds a new Worksheet at the designated location.  
Public MethodOverloaded. Moves a Worksheet or a WorksheetRange to a selected location in the WorksheetCollection.  
Public MethodOverloaded. Removes the Worksheet from the WorksheetCollection and offsets the index of the other Worksheets toward the deleted element.  
Public MethodRemoves a Worksheet from the WorksheetCollection by using an index to locate it in the collection.  
Top
See Also

Reference

WorksheetCollection Class
Xceed.Workbooks.NET Namespace