API Reference
Class
ExcelPivotTableOptions
Workbook-interaction options for authored pivot tables.
Inheritance
- Object
- ExcelPivotTableOptions
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters
- Method ExcelSheet.AddPivotTable
Constructors
public ExcelPivotTableOptions() #Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
public Nullable<Boolean> RefreshOnOpen { get; set; } #Gets or sets whether Excel should refresh the pivot cache when the workbook opens.
public Nullable<Boolean> SaveSourceData { get; set; } #Gets or sets whether source cache records should be saved in the workbook package. Defaults to false so source rows are not duplicated into the pivot cache unless the caller explicitly opts in.
public Nullable<Boolean> PreserveFormatting { get; set; } #Gets or sets whether Excel should preserve pivot table formatting during refreshes.
public Nullable<Boolean> EnableDrill { get; set; } #Gets or sets whether drill-down interaction is enabled for pivot details.