ExcelPivotTableOptions
OfficeIMO.Excel
Layout and workbook-interaction options for authored pivot tables.
Inheritance
- object
- ExcelPivotTableOptions
Usage
Explore 1 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters 1
- Method ExcelSheet.AddPivotTable
Constructors
public ExcelPivotTableOptions() #Inherited Methods
Properties
public int? ValuesAxisPosition { get; set; } #Gets or sets the zero-based placement of Values among fields on its row or column axis. Requires multiple measures. When omitted, Values is placed last.
public bool? RefreshOnOpen { get; set; } #Gets or sets whether Excel should refresh the pivot cache when the workbook opens.
public bool? 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 bool? PreserveFormatting { get; set; } #Gets or sets whether Excel should preserve pivot table formatting during refreshes.
public bool? EnableDrill { get; set; } #Gets or sets whether drill-down interaction is enabled for pivot details.
public string? Name { get; set; } #Gets or sets name for the authored pivot table.
public IList<string> RowFields { get; set; } #Gets the rowFields used when creating the pivot table.
public IList<string> ColumnFields { get; set; } #Gets the columnFields used when creating the pivot table.
public IList<string> PageFields { get; set; } #Gets the pageFields used when creating the pivot table.
public IList<ExcelPivotDataField> DataFields { get; set; } #Gets the dataFields used when creating the pivot table.
public bool ShowRowGrandTotals { get; set; } #Gets or sets showRowGrandTotals for the authored pivot table.
public bool ShowColumnGrandTotals { get; set; } #Gets or sets showColumnGrandTotals for the authored pivot table.
public string? PivotStyleName { get; set; } #Gets or sets pivotStyleName for the authored pivot table.
public ExcelPivotLayout Layout { get; set; } #Gets or sets layout for the authored pivot table.
public bool? DataOnRows { get; set; } #Gets or sets dataOnRows for the authored pivot table.
public bool? ShowHeaders { get; set; } #Gets or sets showHeaders for the authored pivot table.
public bool? ShowEmptyRows { get; set; } #Gets or sets showEmptyRows for the authored pivot table.
public bool? ShowEmptyColumns { get; set; } #Gets or sets showEmptyColumns for the authored pivot table.
public bool? ShowDrill { get; set; } #Gets or sets showDrill for the authored pivot table.
public IList<ExcelPivotFieldOptions> FieldOptions { get; set; } #Gets the fieldOptions used when creating the pivot table.
public string? RowHeaderCaption { get; set; } #Gets or sets rowHeaderCaption for the authored pivot table.
public string? ColumnHeaderCaption { get; set; } #Gets or sets columnHeaderCaption for the authored pivot table.
public string? GrandTotalCaption { get; set; } #Gets or sets grandTotalCaption for the authored pivot table.
public string? MissingCaption { get; set; } #Gets or sets missingCaption for the authored pivot table.
public string? ErrorCaption { get; set; } #Gets or sets errorCaption for the authored pivot table.
public bool? ShowDataDropDown { get; set; } #Gets or sets showDataDropDown for the authored pivot table.
public bool? ShowDropZones { get; set; } #Gets or sets showDropZones for the authored pivot table.
public bool? ShowDataTips { get; set; } #Gets or sets showDataTips for the authored pivot table.
public bool? ShowMemberPropertyTips { get; set; } #Gets or sets showMemberPropertyTips for the authored pivot table.
public bool? FieldListSortAscending { get; set; } #Gets or sets fieldListSortAscending for the authored pivot table.
public bool? CustomListSort { get; set; } #Gets or sets customListSort for the authored pivot table.
public IList<ExcelPivotFilter> PivotFilters { get; set; } #Gets the pivotFilters used when creating the pivot table.
public IList<ExcelPivotCalculatedField> CalculatedFields { get; set; } #Gets the calculatedFields used when creating the pivot table.
public IList<ExcelPivotGrouping> Groupings { get; set; } #Gets the groupings used when creating the pivot table.