Skip to main content
A newer version of this page is available. .
Row

HeaderFooterCode Members

Contains codes which can be used in a header or a footer and interpreted when printing a worksheet.

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 an image.
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
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.
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