PivotTableCollection Class

PivotTableCollection class

Represents the collection of all the PivotTable objects on the specified worksheet.


type PivotTableCollection struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
DisposePerforms application-defined tasks associated with freeing, releasing, orresetting unmanaged resources.
Add_String_String_StringAdds a new PivotTable.
Add_String_String_String_BoolAdds a new PivotTable.
Add_String_Int_Int_StringAdds a new PivotTable.
Add_String_Int_Int_String_BoolAdds a new PivotTable.
Add_String_Int_Int_String_Bool_BoolAdds a new PivotTable.
Add_String_String_String_Bool_BoolAdds a new PivotTable.
Add_PivotTable_String_StringAdds a new PivotTable based on another PivotTable.
Add_PivotTable_Int_Int_StringAdds a new PivotTable based on another PivotTable.
Get_IntGets the PivotTable report by index.
Get_StringGets the PivotTable report by pivottable’s name.
Get_Int_IntGets the PivotTable report by pivottable’s position.
ClearClear all pivot tables.
Remove_PivotTableDeletes the specified PivotTable and delete the PivotTable data
Remove_PivotTable_BoolDeletes the specified PivotTable
RemoveAt_IntDeletes the PivotTable at the specified index and delete the PivotTable data
RemoveAt_Int_BoolDeletes the PivotTable at the specified index
GetCount