...
To format a header or footer in script, include formatting codes within the SetContent() call, for example:
Code Block | ||||
---|---|---|---|---|
| ||||
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 =
pgsetup.GetHeader(HeaderFooterSection.Section.Left);
leftHeader.SetContent("Document name: &F");
HeaderFooterSection centerHeader =
pgsetup.GetHeader(HeaderFooterSection.Section.Center);
centerHeader.SetContent("Basic Report");
HeaderFooterSection rightHeader =
pgsetup.GetHeader(HeaderFooterSection.Section.Right);
rightHeader.SetContent("Generated by OfficeWriter");
HeaderFooterSection leftFooter =
pgsetup.GetFooter(HeaderFooterSection.Section.Left);
leftFooter.SetContent("Created on date &D");
HeaderFooterSection centerFooter =
pgsetup.GetFooter(HeaderFooterSection.Section.Center);
centerFooter.SetContent("Page &P of &N");
HeaderFooterSection rightFooter =
pgsetup.GetFooter(HeaderFooterSection.Section.Right);
rightFooter.SetContent("Create at time &T");
}
}
|
...
- In Microsoft Excel, open the File menu and select Page Setup...
- Select the Header/Footer tab.
- Select a header and/or footer from the drop-down list.
Or, create a custom header/footer.
- Save the spreadsheet.
- In an ExcelWriter script, open the spreadsheet containing headers/footers. Use either ExcelTemplate.Open or ExcelApplication.Open to open the spreadsheet.
- Modify the spreadsheet in script. Do not change the text of headers and footers; if you do, the original formatting will be overwritten and default formatting will be applied.