Skip to main content

XlHeaderFooter Properties

Represents the object that specifies headers and footers of a worksheet.
Name Description
AlignWithMargins Gets or sets a value indicating whether the header or footer edges should be aligned with page margins.
DifferentFirst Gets or sets a value indicating whether the first page of the worksheet has unique headers and footers.
DifferentOddEven Gets or sets a value indicating whether the odd-numbered pages have headers and footers different from those on even-numbered pages.
EvenFooter Gets or sets the text to be displayed in the footer of even-numbered pages.
EvenHeader Gets or sets the text to be displayed in the header of even-numbered pages.
FirstFooter Gets or sets the text to be displayed in the footer of the first worksheet page.
FirstHeader Gets or sets the text to be displayed in the header of the first worksheet page.
OddFooter Gets or sets the text to be displayed in the footer of odd-numbered pages.
OddHeader Gets or sets the text to be displayed in the header of odd-numbered pages.
ScaleWithDoc Gets or sets a value indicating whether headers and footers should be scaled proportionately when print scaling is used to fit information on the specified number of pages.
See Also