GrapeCity.Documents.Excel.IPivotCache

Interface IPivotCache

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents the memory cache for a PivotTable report.

public interface IPivotCache

Properties

Index

Returns the index number of the object within the collection of similar objects.

int Index { get; }

Property Value

int

RecordCount

Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item.

int RecordCount { get; }

Property Value

int

RefreshDate

Returns the date on which the PivotTable cache was last refreshed.

DateTime RefreshDate { get; }

Property Value

System.DateTime

RefreshName

Returns the name of the person who last refreshed the PivotTable cache.

string RefreshName { get; }

Property Value

string

SourceData

Gets or sets the data source for the PivotTable report.

IRange SourceData { get; set; }

Property Value

IRange

Methods

CreatePivotTable(IRange, string)

Creates a PivotTable report based on a PivotCache object.

IPivotTable CreatePivotTable(IRange TableDestination, string TableName = null)

Parameters

TableDestination IRange

The cell in the upper-left corner of the PivotTable report’s destination range (the range on the worksheet where the resulting PivotTable report will be placed). The destination range must be on a worksheet in the workbook that contains the PivotCache object specified by expression.

TableName string

The name of the new PivotTable report.

Returns

IPivotTable

Refresh()

Updates the cache of the PivotTable object.

void Refresh()