SlicerPivotTables Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents information about the collection of PivotTables associated with the specified SlicerCache object.
public interface class SlicerPivotTables : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("000244CB-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SlicerPivotTables : System.Collections.IEnumerable
Public Interface SlicerPivotTables
Implements IEnumerable
- Attributes
- Implements
Remarks
The SlicerPivotTables collection contains information about the PivotTables the slicer cache is currently filtering. It provides properties for determining the number of PivotTables the slicer is associated with, and for retrieving PivotTable objects that represent the PivotTables being filtered. It also provides methods for adding and removing PivotTables from the SlicerPivotTables collection. The SlicerPivotTables collection will be empty if the slicer associated with the specified SlicerCache is not connected to any PivotTables.
Use the PivotTables property of the SlicerCache object to return the SlicerPivotTables collection associated with a SlicerCache, which in turn may be associated with one or more slicers.
Properties
_Default[Object] |
Reserved for internal use. |
Application |
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. |
Count |
Gets the number of objects in the collection. |
Creator |
Gets a 32-bit integer that indicates the application in which this object was created. |
Item[Object] |
Gets a single PivotTable object from the collection. |
Parent |
Gets the SlicerCache object that is the parent of the specified SlicerPivotTables collection. |
Methods
AddPivotTable(PivotTable) |
Adds a reference to a PivotTable to the SlicerPivotTables collection. |
GetEnumerator() | |
RemovePivotTable(Object) |
Removes a reference to a PivotTable from the SlicerPivotTables collection. |
Applies to
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기