[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Expand]Worksheets
   [Expand]Rows and Columns
   [Expand]Cells
   [Expand]Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Shapes
   [Expand]Charts
   [Expand]Sparklines
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Expand]Tables
   [Expand]Pivot Tables
   [Collapse]Printing
     How to: Print a Workbook
     How to: Specify Print Settings
     How to: Show a Print Preview Form for a Workbook
     How to: Add Headers and Footers to a Worksheet Printout
     How to: Define a Print Area
     How to: Print Titles on a Worksheet
     How to: Use the WPF Chart Rendering Mechanism When Printing or Exporting a Workbook to PDF
   [Expand]Pictures
   [Expand]Protection
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Add Headers and Footers to a Worksheet Printout

Use the Worksheet.HeaderFooterOptions property to add headers and footers to the printed pages.

Properties

Description

WorksheetHeaderFooterOptions.FirstHeader,

WorksheetHeaderFooterOptions.FirstFooter

Specify the header and footer for the first page.

WorksheetHeaderFooterOptions.OddHeader,

WorksheetHeaderFooterOptions.OddFooter

Specify the header and footer for odd pages.

WorksheetHeaderFooterOptions.EvenHeader,

WorksheetHeaderFooterOptions.EvenFooter

Specify the header and footer for even pages.

Expanded Header and Footer Options

Property Description
WorksheetHeaderFooterOptions.DifferentOddEven Gets or sets whether odd and even pages have different headers and footers.
WorksheetHeaderFooterOptions.DifferentFirst Gets or sets whether the first page has a unique header and footer.
WorksheetHeaderFooterOptions.ScaleWithDoc Gets or sets whether headers and footers should resize when you scale the worksheet.
WorksheetHeaderFooterOptions.AlignWithMargins Gets or sets whether to align the header and footer margins with the left and right page margins.

Expanded Header and Footer Codes

The Spreadsheet supports special codes you can use to add dynamic data to a header or footer, and format its content. These codes are also available as constant fields and static methods of the HeaderFooterCode class.

Code

HeaderFooterCode Member

Description

&L

HeaderFooterCode.LeftSection

Aligns text to the left.

&C

HeaderFooterCode.CenterSection

Aligns text to the center.

&R

HeaderFooterCode.RightSection

Aligns text to the right.

&P

HeaderFooterCode.PageNumber

Inserts the current page number.

&P+number

HeaderFooterCode.CustomPageNumber

Inserts the current page number plus the specified number.

&P-number

HeaderFooterCode.CustomPageNumber

Inserts the current page number minus the specified number.

&N

HeaderFooterCode.PageTotal

Inserts the total number of pages in a workbook.

&N+number

HeaderFooterCode.CustomPageTotal

Inserts the total number of pages plus the specified number.

&N-number

HeaderFooterCode.CustomPageTotal

Inserts the total number of pages minus the specified number.

&D

HeaderFooterCode.Date

Inserts the current date.

&T

HeaderFooterCode.Time

Inserts the current time.

&Z

HeaderFooterCode.WorkbookFilePath

Inserts the path to the document.

&F

HeaderFooterCode.WorkbookFileName

Inserts the document's name.

&A

HeaderFooterCode.WorksheetName

Inserts the current worksheet's name.

&G

HeaderFooterCode.Picture

Inserts an image.

&&

HeaderFooterCode.Ampersand

Inserts an ampersand.

&B

HeaderFooterCode.Bold

Turns bold formatting on or off.

&I

HeaderFooterCode.Italic

Turns italic formatting on or off.

&U

HeaderFooterCode.Underline

Turns underline formatting on or off.

&E

HeaderFooterCode.DoubleUnderline

Turns double underline formatting on or off.

&S

HeaderFooterCode.Strikethrough

Turns strikethrough formatting on or off.

&Y

HeaderFooterCode.Subscript

Turns subscript formatting on or off.

&X

HeaderFooterCode.Superscript

Turns superscript formatting on or off.

&"font name,font type"

HeaderFooterCode.Font,

HeaderFooterCode.BodyFont,

HeaderFooterCode.HeadingsFont

Specifies the text font.

&nn

HeaderFooterCode.FontSize

Sets the font size.

Use a two-digit number to specify the font size in points.

&KRRGGBB

HeaderFooterCode.FontColor

Sets the font color.

Use hexadecimal numbers to specify color components.

&KTTSNNN

HeaderFooterCode.FontColor

Applies the theme color to the characters.

TT is the theme color Id, S is either "+" or "-" of the tint/shade value, and NNN is the tint/shade value.

Expanded Example

The following example shows how to specify the header and footer for the first page.

Is this topic helpful?​​​​​​​