diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheets.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheets.cs index ab5d28d..ea10629 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheets.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheets.cs @@ -14,6 +14,7 @@ IXLWorksheet Add(String sheetName); IXLWorksheet Add(String sheetName, Int32 position); IXLWorksheet Add(DataTable dataTable); + IXLWorksheet Add(DataTable dataTable, String sheetName); void Add(DataSet dataSet); void Delete(String sheetName); void Delete(Int32 position); diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs index 9493243..8164e53 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs @@ -670,5 +670,10 @@ { worksheet.CopyTo(this, worksheet.Name); } + + public IXLWorksheet AddWorksheet(DataTable dataTable, String sheetName) + { + return Worksheets.Add(dataTable, sheetName); + } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheets.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheets.cs index 35b7f05..673328a 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheets.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheets.cs @@ -139,7 +139,12 @@ public IXLWorksheet Add(DataTable dataTable) { - var ws = Add(dataTable.TableName); + return Add(dataTable, dataTable.TableName); + } + + public IXLWorksheet Add(DataTable dataTable, String sheetName) + { + var ws = Add(sheetName); ws.Cell(1, 1).InsertTable(dataTable); ws.Columns().AdjustToContents(1, 75); return ws;