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 Location Property

Returns pivot table location.

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 CellRange Location { get; set; }

Public Property Location As CellRange
	Get
	Set

public:
virtual property CellRange^ Location {
	CellRange^ get () sealed;
	void set (CellRange^ value) sealed;
}

abstract Location : CellRange with get, set
override Location : CellRange with get, set

XlsPivotTable AddLanguageSpecificTextSet("LST3D1B182E_0?cpp=::|nu=."); Location Property

Property Value

Implements

Reference

XlsPivotTable Location Property