diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs index fd15f91..ded04e3 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs @@ -63,7 +63,8 @@ TableStyleDark4, TableStyleDark3, TableStyleDark2, - TableStyleDark1 + TableStyleDark1, + None } public interface IXLTable : IXLRange diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs index 939cce3..4ca7822 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs @@ -255,8 +255,9 @@ if (dTable.TableStyleInfo.ShowColumnStripes != null) xlTable.ShowColumnStripes = dTable.TableStyleInfo.ShowColumnStripes.Value; if (dTable.TableStyleInfo.Name != null) - xlTable.Theme = - (XLTableTheme) Enum.Parse(typeof (XLTableTheme), dTable.TableStyleInfo.Name.Value); + xlTable.Theme = (XLTableTheme) Enum.Parse(typeof (XLTableTheme), dTable.TableStyleInfo.Name.Value); + else + xlTable.Theme = XLTableTheme.None; } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs index 683595f..b25dfb2 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs @@ -1638,13 +1638,15 @@ var tableStyleInfo1 = new TableStyleInfo { - Name = Enum.GetName(typeof (XLTableTheme), xlTable.Theme), ShowFirstColumn = xlTable.EmphasizeFirstColumn, ShowLastColumn = xlTable.EmphasizeLastColumn, ShowRowStripes = xlTable.ShowRowStripes, ShowColumnStripes = xlTable.ShowColumnStripes }; + if (xlTable.Theme != XLTableTheme.None) + tableStyleInfo1.Name = Enum.GetName(typeof(XLTableTheme), xlTable.Theme); + if (xlTable.ShowAutoFilter) { var autoFilter1 = new AutoFilter();