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

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

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 PivotTable object

Declaration

public ExcelPivotTable PivotTable { get; }

Property Value

Type	Description
ExcelPivotTable

SaveData

If Excel will save the source data with the pivot table.

Declaration

public bool SaveData { get; set; }

Property Value

Type	Description
System.Boolean

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