Formatting Headers and Footers

The following properties of PageSetup allow you to create and format spreadsheet headers and footers:

• CenterFooter
• CenterHeader
• LeftFooter
• LeftHeader
• RightFooter
• RightHeader
• HeaderMargin
• FooterMargin

To see spreadsheet headers and footers in Excel, open the File menu, select Page Setup, and select the Header/Footer tab.

To format a header or footer in script, include formatting codes within the ExcelWriter header/footer property, for example:

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;
		pgsetup.LeftHeader = "Document name: &F";
		pgsetup.CenterHeader = "Basic Report";
		pgsetup.RightHeader = "Generated by OfficeWriter";
		pgsetup.LeftFooter = "Created on date &D";
		pgsetup.CenterFooter = "Page &P of &N";
		pgsetup.RightFooter = "Create at time &T";

		...
	}
}

Formatting Headers and Footers in Microsoft Excel

When opening an existing Excel spreadsheet, ExcelWriter will preserve the header and footer formatting created in Excel. However, if you change the header/footer text in your ExcelWriter script and do not include Formatting Codes, the formatting created in Excel will be overwritten, and default formatting applied. To preserve header/footer formatting created in Excel, do not change header/footer text in script.

To format spreadsheet headers and footers in Excel and preserve the formatting in ExcelWriter:

1. In Microsoft Excel, open the File menu and select Page Setup...



2. Select the Header/Footer tab.



3. Select a header and/or footer from the drop-down list.
   
   
   
   Or, create a custom header/footer.
   
   



4. Save the spreadsheet.



5. In an ExcelWriter script, open the spreadsheet containing headers/footers. Use either ExcelTemplate or ExcelApplication.Open to open the spreadsheet.



6. 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 applied.

Copyright 2007 © SoftArtisans, Inc. All Rights Reserved.