Back to Devexpress

PivotTableCollection.Item[String] Property

officefileapi-devexpress-dot-spreadsheet-dot-pivottablecollection-dot-item-x28-system-dot-string-x29.md

latest2.3 KB
Original Source

PivotTableCollection.Item[String] Property

Provides access to an individual pivot table in the collection by its name.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
PivotTable this[string name] { get; }
vb
ReadOnly Property Item(name As String) As PivotTable

Parameters

NameTypeDescription
nameString

A string that specifies the name of the pivot table to be obtained. This value matches the value of the PivotTable.Name property.

|

Property Value

TypeDescription
PivotTable

A PivotTable object that is a pivot table with the specified name.

|

Remarks

Use the Item property to obtain a pivot table by its name from the worksheet’s collection of pivot tables. When searching, the name parameter value is compared to the PivotTable.Name property of the PivotTable objects. If no matches are found, this method returns null ( Nothing in Visual Basic).

See Also

Pivot Tables in Spreadsheet Documents

Pivot Table API

How to: Create a Pivot Table

PivotTableCollection Interface

PivotTableCollection Members

DevExpress.Spreadsheet Namespace