Thom Lamb
2cd6df6481
Establishes the foundational structure, core Excel functionality, and tooling. - Implements base components for cells, ranges, columns, and rows. - Integrates a custom calculation engine with a wide range of Excel functions. - Adds comprehensive support for styling, conditional formatting, data validation, comments, pictures, and charts. - Configures build setup, project metadata (NuGet), and developer guidelines. - Includes editor and Git attributes for consistent code style and line endings.
52 lines
1.5 KiB
C#
52 lines
1.5 KiB
C#
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);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|