Page History

using SoftArtisans.OfficeWriter.ExcelWriter;

public class HeaderFooterDemo : System.Web.UI.Page
{
     protected void Page_Load(object sender, System.EventArgs e)
     {
          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet sheet1 = wb.Worksheets[0];
          PageSetup pgsetup = sheet1.PageSetup;
          HeaderFooterSection leftHeader =
                PageSetuppgsetup.GetHeader(HeaderFooterSection.Section.Left);
          leftHeader.SetContent("Document name: &F");
          HeaderFooterSection centerHeader =
                PageSetuppgsetup.GetHeader(HeaderFooterSection.Section.Center);
          centerHeader.SetContent("Basic Report");
          HeaderFooterSection rightHeader =
                PageSetuppgsetup.GetHeader(HeaderFooterSection.Section.Right);
          rightHeader.SetContent("Generated by OfficeWriter");
          HeaderFooterSection leftFooter =
                PageSetuppgsetup.GetFooter(HeaderFooterSection.Section.Left);
          leftFooter.SetContent("Created on date &D");
          HeaderFooterSection centerFooter =
                PageSetuppgsetup.GetFooter(HeaderFooterSection.Section.Center);
          centerFooter.SetContent("Page &P of &N");
          HeaderFooterSection rightFooter =
                PageSetuppgsetup.GetFooter(HeaderFooterSection.Section.Right);
          rightFooter.SetContent("Create at time &T");
     }
}