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

Gets the worksheet associated with the current instance.

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 XlsWorksheet Worksheet { get; }

Public ReadOnly Property Worksheet As XlsWorksheet
	Get

public:
property XlsWorksheet^ Worksheet {
	XlsWorksheet^ get ();
}

member Worksheet : XlsWorksheet with get

Property Value

Type: XlsWorksheet

Reference

XlsPivotTable Class

Spire.Xls.Core.Spreadsheet.PivotTables Namespace

XlsPivotTable AddLanguageSpecificTextSet("LST38ADD744_0?cpp=::|nu=."); Worksheet Property

Property Value

Reference

XlsPivotTable Worksheet Property