XlHeaderFooter Members
Represents the object that specifies headers and footers of a worksheet.Constructors
Name | Description |
---|---|
XlHeaderFooter() | Initializes a new instance of the XlHeaderFooter class with the default settings. |
Fields
Name | Description |
---|---|
Bold | Turns bold on or off for the characters that follows. |
BookName | Prints the name of the workbook. |
BookPath | Prints the workbook file path. |
Center | Centers the characters that follow. |
Date | Prints the current date. |
DoubleUnderline | Turns double underline on or off for the characters that follow. |
Italic | Turns italic on or off for the characters that follow. |
Left | Left aligns the characters that follow. |
PageNumber | Prints the current page number. |
PageTotal | Prints the total number of pages in the document. |
Right | Right aligns the characters that follow. |
SheetName | Prints the name of the worksheet. |
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. |
Properties
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. |
Methods
Name | Description |
---|---|
Clear() | Removes headers and footers from a worksheet. |
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. |
FromLCR(String, String, String) static | Specifies the left-aligned, centered and right-aligned text for the header of footer. |
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