Class ExcelPivotCacheDefinition

Cache definition. This class defines the source data. Note that one cache definition can be shared between many pivot tables.

Inheritance
System.Object
XmlHelper
ExcelPivotCacheDefinition
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotCacheDefinition : XmlHelper

Properties

CacheDefinitionUri

The package internal URI to the pivottable cache definition Xml Document.

Declaration
public Uri CacheDefinitionUri { get; }
Property Value
Type Description
System.Uri

CacheDefinitionXml

Provides access to the XML data representing the cache definition in the package.

Declaration
public XmlDocument CacheDefinitionXml { get; }
Property Value
Type Description
System.Xml.XmlDocument

CacheSource

Type of source data

Declaration
public eSourceType CacheSource { get; }
Property Value
Type Description
eSourceType

PivotTable

Referece to the PivoTable object

Declaration
public ExcelPivotTable PivotTable { get; }
Property Value
Type Description
ExcelPivotTable

SourceRange

The source data range when the pivottable has a worksheet datasource. The number of columns in the range must be intact if this property is changed. The range must be in the same workbook as the pivottable.

Declaration
public ExcelRangeBase SourceRange { get; set; }
Property Value
Type Description
ExcelRangeBase