Page History

Introducedin

	8.4
	8.4

Description

Excerpt
The ItemsToRetain class represents the number of items a pivot table PivotTable cache will retain even changes have been made to the data source.

...

Example

Code Block

	csharp
	csharp
title	C#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.CreateOpen("template.xlsx");
          ItemsToRetain items = wb[0].PivotTables[0].PivotTableSettings.ItemsToRetain;

Code Block

	vbnet
	vbnet
title	vb.net


          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.CreateOpen("template.xlsx")
          Dim palitems As ItemsToRetain = wb[(0]).PivotTables[(0]).PivotTableSettings.ItemsToRetain;

...

Name

Description

Automatic

Excerpt Include

	EW8:ItemsToRetain.AutomaticEW8:
	ItemsToRetain.Automatic
nopanel	true

None

Excerpt Include

	EW8:ItemsToRetain.NoneEW8:
	ItemsToRetain.None
nopanel	true

...

Name

Description

Max

Excerpt Include

	EW8:ItemsToRetain.MaxEW8:
	ItemsToRetain.Max
nopanel	true

Value

Excerpt Include

	EW8:ItemsToRetain.ValueEW8:
	ItemsToRetain.Value
nopanel	true

Remarks
Setting `PivotTableSettings.ItemsToRetain` is the same as going to PivotTable Options > Data > Retain items deleted from the data source and setting Number of items to retain per field to Automatic, Max, None, or a different integer value.

Space Shortcuts

Page tree

Versions Compared

Old Version 6

New Version Current

Key