Click or drag to resize

Spire.Xls.Core.Spreadsheet.PivotTables Namespace

Classes
Class Description
Public class AutoSortScope
Preserves the sorting elements of the field.
Public class PivotCalculatedFieldsCollection
Represents a collection of calculated fields used in a pivot table to perform calculations on data.
Public class PivotConditionalFormat
Represents a conditional format that can be applied to a pivot table in a spreadsheet application. This class allows you to define rules and styles that are applied to pivot table cells based on specific conditions.
Public class PivotConditionalFormatCollection
Represents a collection of conditional formats that can be applied to pivot table cells based on specific conditions.
Public class PivotDataField
Represents a data field in a pivot table, which is used to perform aggregate calculations such as sum, average, count, etc.
Public class PivotDataFields
Represents a collection of data fields used in a pivot table to define the data that is summarized and displayed.
Public class PivotItem
Represents a item in a PivotField report.
Public class PivotReportFilter
Represent the report filter of PivotTable
Public class PivotReportFilters
Represents a collection of filters used to refine the data in a pivot report.
Public class PivotStyle
Represents the style and appearance settings for a pivot table
Public class PivotTableStyle
Represents a style that can be applied to a pivot table in a spreadsheet application. This class encapsulates various styling properties that can be customized to enhance the visual presentation of pivot tables.
Public class XlsPivotCache
Represents a pivot cache in an Excel workbook, which is used to store and manage the data for one or more PivotTables.
Public class XlsPivotCacheField
Represents a field in a pivot cache, which is used in Excel to store and organize data for pivot tables.
Public class XlsPivotField
Represents a pivot field in an Excel pivot table, encapsulating the properties and behaviors of a field within a pivot table.
Public class XlsPivotTable
Represents a pivot table in an Excel worksheet, providing functionalities to manipulate and retrieve data from pivot tables.