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.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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

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 pivottable.

public ExcelRangeBase SourceRange { get; set; }

Property Value

ExcelRangeBase

Methods

Refresh()

Refreshes the pivot tables cache.

public void Refresh()