diff --git a/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML_Tests/ClosedXML_Tests.csproj index 80cf986..e4c8d7a 100644 --- a/ClosedXML_Tests/ClosedXML_Tests.csproj +++ b/ClosedXML_Tests/ClosedXML_Tests.csproj @@ -75,6 +75,7 @@ + diff --git a/ClosedXML_Tests/Excel/PageSetup/HeaderFooterTests.cs b/ClosedXML_Tests/Excel/PageSetup/HeaderFooterTests.cs new file mode 100644 index 0000000..d1748a9 --- /dev/null +++ b/ClosedXML_Tests/Excel/PageSetup/HeaderFooterTests.cs @@ -0,0 +1,37 @@ +using ClosedXML.Excel; +using NUnit.Framework; +using System.IO; +using System.Linq; + +namespace ClosedXML_Tests.Excel +{ + [TestFixture] + public class HeaderFooterTests + { + [Test] + public void CanChangeWorksheetHeader() + { + var wb = new XLWorkbook(); + IXLWorksheet ws = wb.AddWorksheet("Sheet1"); + + ws.PageSetup.Header.Center.AddText("Initial page header", XLHFOccurrence.EvenPages); + + var ms = new MemoryStream(); + wb.SaveAs(ms); + + wb = new XLWorkbook(ms); + ws = wb.Worksheets.First(); + + ws.PageSetup.Header.Center.Clear(); + ws.PageSetup.Header.Center.AddText("Changed header", XLHFOccurrence.EvenPages); + + wb.SaveAs(ms); + + wb = new XLWorkbook(ms); + ws = wb.Worksheets.First(); + + var newHeader = ws.PageSetup.Header.Center.GetText(XLHFOccurrence.EvenPages); + Assert.AreEqual("Changed header", newHeader); + } + } +} \ No newline at end of file