Namespace: Spire.Xls.Core.Spreadsheet.PivotTables
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 11.6.0.0 (11.6.0.5020)

Syntax

            
 C#  Visual Basic  Visual C++  F# 
public class XlsPivotTable : XlsObject, 
	IPivotTable
Public Class XlsPivotTable
	Inherits XlsObject
	Implements IPivotTable
public ref class XlsPivotTable : public XlsObject, 
	IPivotTable
type XlsPivotTable =  
    class
        inherit XlsObject
        interface IPivotTable
    end

Members

               
 All Members  Constructors   Fields   Properties   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
XlsPivotTable(Object, Int32, IXLSRange)
Initializes a new instance of the XlsPivotTable class
AddReference()()()() (Inherited from XlsObject.)
AllSubTotalTop
AutoFormatType
BuiltInStyle
Cache
CacheIndex
CalculateData()()()()
CalculatedFields
ChangeDataSource(IXLSRange)
CheckDisposed()()()() (Inherited from XlsObject.)
Clear()()()()
ClearColumnFieldFilter(String)
ClearFilter(String)
ClearRowFieldFilter(String)
Clone(Object)
Clone(Object, Int32, Dictionary<(Of <<'(String, String>)>>))
ColumnFields
ColumnsPerPage
CustomTableStyleName
DataFields
DisplayErrorString
DisplayFieldCaptions
DisplayNullString
Dispose()()()() (Inherited from XlsObject.)
EnableDrilldown
EnableFieldDialog
EnableWizard
Equals(Object)
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
ErrorString
Finalize()()()() (Inherited from XlsObject.)
FindParent(Type) (Inherited from XlsObject.)
FindParent(array<Type>[]()[][]) (Inherited from XlsObject.)
FindParent(Type, Boolean) (Inherited from XlsObject.)
FindParents(array<Type>[]()[][]) (Inherited from XlsObject.)
FirstDataCol
FirstDataRow
FirstHeaderRow
GetHashCode()()()()
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType()()()()
Gets the Type of the current instance.
(Inherited from Object.)
IsColumnGrand
IsCompatibleWithExcel2003
IsRowGrand
Location
m_bIsDisposed (Inherited from XlsObject.)
ManualUpdate
MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
MergeLabels
Name
NullString
OnDispose()()()() (Inherited from XlsObject.)
Options
PageFieldOrder
PageFields
PageFieldStyle
PageFieldWrapCount
Parent
PivotConditionalFormats
PivotFields
ReferenceCount (Inherited from XlsObject.)
ReleaseReference()()()() (Inherited from XlsObject.)
RepeatItemsOnEachPrintedPage
ReportFilters
RowFields
RowsPerPage
SetParent(Object) (Inherited from XlsObject.)
ShowColHeaderStyle
ShowColStripes
ShowColumnGrand
ShowDataFieldInRow
ShowDrillIndicators
ShowLastCol
ShowRowGrand
ShowRowHeaderStyle
ShowRowStripes
ShowSubtotals
ToString()()()()
Returns a String that represents the current Object.
(Inherited from Object.)
Workbook
Worksheet

Inheritance Hierarchy

System..::..Object
  Spire.Xls.Core.Spreadsheet..::..XlsObject
    Spire.Xls.Core.Spreadsheet.PivotTables..::..XlsPivotTable
      Spire.Xls..::..PivotTable

See Also