WorksheetCollection Class |
Namespace: Aspose.Cells
The WorksheetCollection type exposes the following members.
Name | Description | |
---|---|---|
![]() | ActiveSheetIndex |
Represents the index of active worksheet when the spreadsheet is opened.
|
![]() ![]() | BuiltInDocumentProperties |
Returns a DocumentProperties collection that represents all the built-in document properties of the spreadsheet.
|
![]() | Capacity | (Inherited from CollectionBase.) |
![]() | Count | (Inherited from CollectionBase.) |
![]() ![]() | CustomDocumentProperties |
Returns a DocumentProperties collection that represents all the custom document properties of the spreadsheet.
|
![]() | Dxfs |
Gets the master differential formatting records.
|
![]() | ExternalLinks |
Represents external links in a workbook.
|
![]() | InnerList | (Inherited from CollectionBase.) |
![]() | IsRefreshAllConnections |
Indicates whether refresh all connections on opening file in MS Excel.
|
![]() | ItemInt32 |
Gets the Worksheet element at the specified index.
|
![]() | ItemString |
Gets the Worksheet element with the specified name.
|
![]() | List | (Inherited from CollectionBase.) |
![]() | Names |
Gets the collection of all the Name objects in the spreadsheet.
|
![]() | OleSize |
Gets and Sets displayed size when Workbook file is used as an Ole object.
|
![]() | RevisionLogs |
Represents revision logs.
|
![]() | TableStyles |
Gets TableStyles object.
|
![]() | ThreadedCommentAuthors |
Gets the list of threaded comment authors.
|
![]() | WebExtensions |
Gets the list of task panes.
|
![]() | WebExtensionTaskPanes |
Gets the list of task panes.
|
![]() | XmlMaps |
Gets and sets the XML maps in the workbook.
|
Name | Description | |
---|---|---|
![]() | Add |
Adds a worksheet to the collection.
|
![]() | Add(String) |
Adds a worksheet to the collection.
|
![]() ![]() | Add(SheetType) |
Adds a worksheet to the collection.
|
![]() | AddCopy(Int32) |
Adds a worksheet to the collection and copies data from an existed worksheet.
|
![]() | AddCopy(String) |
Adds a worksheet to the collection and copies data from an existed worksheet.
|
![]() | Clear |
Clear all worksheets.
|
![]() | ClearPivottables |
Clears pivot tables from the spreadsheet.
|
![]() | CreateRange |
Creates a Range object from an address of the range.
|
![]() | CreateUnionRange |
Creates a Range object from an address of the range.
|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetEnumerator | (Inherited from CollectionBase.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetNamedRanges |
Gets all pre-defined named ranges in the spreadsheet.
|
![]() | GetNamedRangesAndTables |
Gets all pre-defined named ranges in the spreadsheet.
|
![]() | GetRangeByName |
Gets Range object by pre-defined name.
|
![]() | GetSheetByCodeName |
Gets the worksheet by the code name.
|
![]() | GetType | (Inherited from Object.) |
![]() | Insert(Int32, SheetType) |
Insert a worksheet.
|
![]() | Insert(Int32, SheetType, String) |
Insert a worksheet.
|
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | OnClear | (Inherited from CollectionBase.) |
![]() | OnClearComplete | (Inherited from CollectionBase.) |
![]() | OnInsert | (Inherited from CollectionBase.) |
![]() | OnInsertComplete | (Inherited from CollectionBase.) |
![]() | OnRemove | (Inherited from CollectionBase.) |
![]() | OnRemoveComplete | (Inherited from CollectionBase.) |
![]() | OnSet | (Inherited from CollectionBase.) |
![]() | OnSetComplete | (Inherited from CollectionBase.) |
![]() | OnValidate | (Inherited from CollectionBase.) |
![]() | RefreshPivotTables |
Refreshes all the PivotTables in the WorksheetCollection.
|
![]() | RegisterAddInFunction(Int32, String) |
Adds addin function into the workbook
|
![]() | RegisterAddInFunction(String, String, Boolean) |
Adds addin function into the workbook
|
![]() | RemoveAt(Int32) |
Removes the element at a specified index.
|
![]() | RemoveAt(String) |
Removes the element at a specified name.
|
![]() | SetOleSize |
Sets displayed size when Workbook file is used as an Ole object.
|
![]() | SortNames |
Sorts the defined names.
|
![]() | SwapSheet |
Swaps the two sheets.
|
![]() | ToString | (Inherited from Object.) |
[C#] Workbook workbook = new Workbook(); WorksheetCollection sheets = workbook.Worksheets; //Add a worksheet sheets.Add(); //Change the name of a worksheet sheets[0].Name = "First Sheet"; //Set the active sheet to the second worksheet sheets.SetActiveSheet(1); [Visual Basic] Dim excel as Workbook = new Workbook() Dim sheets as WorksheetCollection = excel.Worksheets 'Add a worksheet sheets.Add() 'Change the name of a worksheet sheets(0).Name = "First Sheet" 'Set the active sheet to the second worksheet sheets.SetActiveSheet(1)