WorksheetCollection

WorksheetCollection

Overview

WorksheetCollection is a class in Aspose.Cells for NET. Inherits from: IEnumerable<Worksheet>.

WorksheetCollection.Add adds a new worksheet with a default name to the workbook.

Properties

NameTypeAccessDescription
CountintReadGets the total number of worksheets in the collection
ActiveSheetIndexintRead/Write
ActiveSheetNamestringRead/WriteGets or sets the name of the currently active worksheet

Methods

SignatureDescription
Add()Adds a new worksheet with a default name to the workbook
Add(sheetName: string)
RemoveAt(sheetName: string)Removes the worksheet with the specified name
RemoveAt(index: int)
GetEnumerator()Returns an iterator over the worksheets in order