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, true);
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, true);
wb = new XLWorkbook(ms);
ws = wb.Worksheets.First();
var newHeader = ws.PageSetup.Header.Center.GetText(XLHFOccurrence.EvenPages);
Assert.AreEqual("Changed header", newHeader);
}
[TestCase("")]
[TestCase("&L&C&\"Arial\"&9 19-10-2017 \n&9&\"Arial\" &P &N &R")] // https://github.com/ClosedXML/ClosedXML/issues/563
public void CanSetHeaderFooter(string s)
{
using (var wb = new XLWorkbook())
{
var ws = wb.AddWorksheet("Sheet1");
{
var header = ws.PageSetup.Header as XLHeaderFooter;
header.SetInnerText(XLHFOccurrence.AllPages, s);
}
}
}
}
}