Class ExcelPivotCacheDefinition¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

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

public class ExcelPivotCacheDefinition

Inheritance¶

object ← ExcelPivotCacheDefinition

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

CacheDefinitionUri¶

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

public Uri CacheDefinitionUri { get; }

Property Value¶

Uri

CacheDefinitionXml¶

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

public XmlDocument CacheDefinitionXml { get; }

Property Value¶

XmlDocument

CacheSource¶

Type of source data

public eSourceType CacheSource { get; }

Property Value¶

eSourceType

Connection¶

The external connection used as source for this pivot table.

public ExcelConnection Connection { get; }

Property Value¶

ExcelConnection

PivotTable¶

Referece to the PivotTable object

public ExcelPivotTable PivotTable { get; }

Property Value¶

ExcelPivotTable

SaveData¶

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

public bool SaveData { get; set; }

Property Value¶

bool

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 pivot table.

public ExcelRangeBase SourceRange { get; set; }

Property Value¶

ExcelRangeBase

Methods¶

Refresh()¶

Refreshes the pivot tables cache.

public void Refresh()