PivotTableCollection Class
Contents
[
Hide
]PivotTableCollection class
Represents the collection of all the PivotTable objects on the specified worksheet.
type PivotTableCollection struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| Dispose | Performs application-defined tasks associated with freeing, releasing, orresetting unmanaged resources. |
| Add_String_String_String | Adds a new PivotTable. |
| Add_String_String_String_Bool | Adds a new PivotTable. |
| Add_String_Int_Int_String | Adds a new PivotTable. |
| Add_String_Int_Int_String_Bool | Adds a new PivotTable. |
| Add_String_Int_Int_String_Bool_Bool | Adds a new PivotTable. |
| Add_String_String_String_Bool_Bool | Adds a new PivotTable. |
| Add_PivotTable_String_String | Adds a new PivotTable based on another PivotTable. |
| Add_PivotTable_Int_Int_String | Adds a new PivotTable based on another PivotTable. |
| Add_stringArray_Bool_PivotPageFields_String_String | Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source. |
| Add_stringArray_Bool_PivotPageFields_Int_Int_String | Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source. |
| Get_Int | Gets the PivotTable report by index. |
| Get_String | Gets the PivotTable report by pivottable’s name. |
| Get_Int_Int | Gets the PivotTable report by pivottable’s position. |
| Clear | Clear all pivot tables. |
| Remove_PivotTable | Deletes the specified PivotTable and delete the PivotTable data |
| Remove_PivotTable_Bool | Deletes the specified PivotTable |
| RemoveAt_Int | Deletes the PivotTable at the specified index and delete the PivotTable data |
| RemoveAt_Int_Bool | Deletes the PivotTable at the specified index |
| GetCount |