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