Click or drag to resize

Workbook PivotCaches Property

Returns pivot caches collection. Read-only.
Examples
The following code snippet illustrates how to get pivot caches:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Gets pivot caches collection</para><para>IPivotCaches pivotCaches = workbook.PivotCaches;</para>

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public PivotCachesCollection PivotCaches { get; }

Property Value

Type: PivotCachesCollection
See Also