Skip to main content
Row

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.
See Also