Click or drag to resize

Spire.Xls.Collections Namespace

Classes
Class Description
Public class AddInFunctionsCollection
Represents a collection of add-in functions that can be utilized within an application to extend its functionality.
Public class AutoFiltersCollection
Represents a collection of automatic filters that can be applied to data in a spreadsheet or similar data grid. Each filter in the collection can define criteria for displaying rows or columns based on specific conditions.
Public class BordersCollection
Represents a collection of borders.
Public class BuiltInDocumentProperties
Returns collection that represents all the built-in document properties.
Public class ChartsCollection
Represents a collection of chart objects.
Public class CommentsCollection
Represents a collection of comments.
Public class DataConnections
Represents a class responsible for managing data connections.
Public class ExternalLinkCollection
Represents a collection of external links.
Public class FontsCollection
Represents a collection of fonts used within an application, providing methods to manage and retrieve font resources.
Public class HPageBreaksCollection
Represents a collection of horizontal page breaks in a worksheet.
Public class HyperLinksCollection
Represents a collection of hyperlinks, providing methods to manage and access individual hyperlinks.
Public class PicturesCollection
Represents a collection of pictures that can be managed and manipulated within an application.
Public class PivotCachesCollection
Represents a collection of PivotCache objects in an Excel workbook. Each PivotCache object contains the data used by one or more PivotTables.
Public class PivotTablesCollection
Represents a collection of PivotTable objects in a worksheet, allowing for the management and manipulation of pivot tables.
Public class QueryTableCollection
Represents a collection of query tables used for database operations.
Public class RangesCollection
Represents a collection of range objects, providing methods to manipulate and query the ranges.
Public class StylesCollection
Represents a collection of styles that can be applied to various UI elements.
Public class VPageBreaksCollection
Represents a collection of vertical page breaks in a worksheet.
Public class WorkbookObjectsCollection
Represents a collection of ChartSheet objects.
Public class WorksheetChartsCollection
Represents a collection of charts in a worksheet.
Public class WorksheetConditionalFormats
Represents a collection of conditional formats applied to a worksheet in a spreadsheet application.
Public class WorksheetsCollection
Represents a collection of Worksheet objects, providing methods and properties for managing multiple worksheets within a workbook.