HeaderFooterCode Members

Contains format codes used in headers and footers.

Fields

Name	Description
Ampersand	Prints a single ampersand.
Bold	Turns bold on and off for the text that follows the code.
CenterSection	Centers the characters that follow.
Date	Prints the current date.
DoubleUnderline	Turns double underline on and off for the characters that follow.
Italic	Turns italic on and off for the characters that follow.
LeftSection	Left aligns the characters that follow.
PageNumber	Prints the current page number.
PageTotal	Prints the total number of pages in the document.
Picture	Inserts a picture. Use the WorksheetHeaderFooter.AddPicture method to load the picture you want to insert.
RightSection	Right aligns the characters that follow.
Strikethrough	Turns strikethrough on or off for the characters that follow.
Subscript	Turns subscript on or off for the characters that follow.
Superscript	Turns superscript on or off for the characters that follow.
Time	Prints the current time.
Underline	Turns underline on or off for the characters that follow.
WorkbookFileName	Prints the name of the workbook.
WorkbookFilePath	Prints the file path of the workbook.
WorksheetName	Prints the name of the worksheet.

Methods

Name	Description
BodyFont(SpreadsheetFontStyle) static	Returns the format code that prints the characters by using the minor theme font and the specified font style.
CustomPageNumber(Int32) static	Returns the header and footer code that prints the page number plus/minus the specified number.
CustomPageTotal(Int32) static	Returns the header and footer code that prints the total number of pages plus/minus the specified number.
Equals(Object, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current object. Inherited from Object.
Font(String, SpreadsheetFontStyle) static	Prints the characters using the specified font.
FontColor(Color) static	Obtains the formatting code that sets the text font color.
FontColor(Int32, Int32) static	Obtains the formatting code that sets the text font color.
FontSize(Int32) static	Obtains the format code that sets the text font size.
GetHashCode()	Serves as the default hash function. Inherited from Object.
GetType()	Gets the Type of the current instance. Inherited from Object.
HeadingsFont(SpreadsheetFontStyle) static	Returns the format code that prints the characters by using the major theme font and the specified font style.
MemberwiseClone() protected	Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static	Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString()	Returns a string that represents the current object. Inherited from Object.