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