diff --git a/ClosedXML/Excel/PivotTables/IXLPivotTables.cs b/ClosedXML/Excel/PivotTables/IXLPivotTables.cs index ce11a21..14fd0bc 100644 --- a/ClosedXML/Excel/PivotTables/IXLPivotTables.cs +++ b/ClosedXML/Excel/PivotTables/IXLPivotTables.cs @@ -9,6 +9,8 @@ IXLPivotTable AddNew(String name, IXLCell target, IXLRange source); + IXLPivotTable AddNew(String name, IXLCell target, IXLTable table); + Boolean Contains(String name); void Delete(String name); diff --git a/ClosedXML/Excel/PivotTables/XLPivotTables.cs b/ClosedXML/Excel/PivotTables/XLPivotTables.cs index 7bb7ac3..5d6a471 100644 --- a/ClosedXML/Excel/PivotTables/XLPivotTables.cs +++ b/ClosedXML/Excel/PivotTables/XLPivotTables.cs @@ -30,6 +30,15 @@ return pivotTable; } + public IXLPivotTable AddNew(string name, IXLCell target, IXLTable table) + { + var dataRange = table.DataRange; + var header = table.HeadersRow(); + var range = table.Worksheet.Range(header.FirstCell(), dataRange.LastCell()); + + return AddNew(name, target, range); + } + public Boolean Contains(String name) { return _pivotTables.ContainsKey(name);