Class ExcelPivotCacheDefinition

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

Inheritance

object

ExcelPivotCacheDefinition

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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
Uri

CacheDefinitionXml

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

Declaration

public XmlDocument CacheDefinitionXml { get; }

Property Value

Type	Description
XmlDocument

CacheSource

Type of source data

Declaration

public eSourceType CacheSource { get; }

Property Value

Type	Description
eSourceType

Connection

The external connection used as source for this pivot table.

Declaration

public ExcelConnection Connection { get; }

Property Value

Type	Description
ExcelConnection

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

Declaration

public ExcelRangeBase SourceRange { get; set; }

Property Value

Type	Description
ExcelRangeBase

Methods

Refresh()

Refreshes the pivot tables cache.

Declaration

public void Refresh()