Add Method

Office Open XML

Create a pivottable on the supplied range

Namespace:  OfficeOpenXml.Table.PivotTable
Assembly:  EPPlus (in EPPlus.dll) Version: 3.0.0.1 (3.0.0.1)

Syntax

C#
public ExcelPivotTable Add(
	ExcelAddressBase Range,
	ExcelRangeBase Source,
	string Name
)
Visual Basic (Declaration)
Public Function Add ( _
	Range As ExcelAddressBase, _
	Source As ExcelRangeBase, _
	Name As String _
) As ExcelPivotTable
Visual C++
public:
ExcelPivotTable^ Add(
	ExcelAddressBase^ Range, 
	ExcelRangeBase^ Source, 
	String^ Name
)

Parameters

Range
Type: OfficeOpenXml..::.ExcelAddressBase
The range address including header and total row
Source
Type: OfficeOpenXml..::.ExcelRangeBase
The Source data range address
Name
Type: System..::.String
The name of the table. Must be unique

Return Value

The pivottable object

See Also