The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

PivotTableCollection.Add Method

Name Parameters Description
Add(CellRange, CellRange) sourceRange, location

Creates a pivot table with the default name based on data in the specified cell range and returns the newly created PivotTable object.

Add(CellRange, CellRange, String) sourceRange, location, name

Creates a pivot table with a custom name based on data in the specified cell range and returns the newly created PivotTable object.

Add(PivotCache, CellRange) cache, location

Creates a new pivot table with the default name using the specified data cache and returns the newly created PivotTable object.

Add(PivotCache, CellRange, String) cache, location, name

Creates a new pivot table with a custom name using the specified data cache and returns the newly created PivotTable object.