Spire.XLS API

Spire.XLS namespace

Spire.Xls.Core.Spreadsheet.PivotTables

XlsPivotTable Class

XlsPivotTable Properties

AllSubTotalTop Property

AutoFormatType Property

BuiltInStyle Property

Cache Property

CacheIndex Property

CalculatedFields Property

ColumnFields Property

ColumnsPerPage Property

CustomTableStyleName Property

DataFields Property

DisplayErrorString Property

DisplayFieldCaptions Property

DisplayNullString Property

EnableDrilldown Property

EnableFieldDialog Property

EnableWizard Property

ErrorString Property

FirstDataCol Property

FirstDataRow Property

FirstHeaderRow Property

IsColumnGrand Property

IsCompatibleWithExcel2003 Property

IsRowGrand Property

Location Property

ManualUpdate Property

PageFieldOrder Property

PageFields Property

PageFieldStyle Property

PageFieldWrapCount Property

Parent Property

PivotConditionalFormats Property

PivotFields Property

RepeatItemsOnEachPrintedPage Property

ReportFilters Property

RowFields Property

RowsPerPage Property

ShowColHeaderStyle Property

ShowColStripes Property

ShowColumnGrand Property

ShowDataFieldInRow Property

ShowDrillIndicators Property

ShowLastCol Property

ShowRowGrand Property

ShowRowHeaderStyle Property

ShowRowStripes Property

ShowSubtotals Property

Workbook Property

Worksheet Property

XlsPivotTable Options Property

Represents the pivot table options.Read-only

Namespace: Spire.Xls.Core.Spreadsheet.PivotTables
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

public IPivotTableOptions Options { get; }

Public ReadOnly Property Options As IPivotTableOptions
	Get

public:
virtual property IPivotTableOptions^ Options {
	IPivotTableOptions^ get () sealed;
}

abstract Options : IPivotTableOptions with get
override Options : IPivotTableOptions with get

XlsPivotTable AddLanguageSpecificTextSet("LSTA9890FE4_0?cpp=::|nu=."); Options Property

Property Value

Implements

Reference

XlsPivotTable Options Property