XlHeaderFooter Members
In This Article
#Constructors
Name | Description |
---|---|
Xl |
Initializes a new instance of the Xl |
#Fields
Name | Description |
---|---|
Bold | Turns bold on or off for the characters that follows. |
Book |
Prints the name of the workbook. |
Book |
Prints the workbook file path. |
Center | Centers the characters that follow. |
Date | Prints the current date. |
Double |
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. |
Page |
Prints the current page number. |
Page |
Prints the total number of pages in the document. |
Right | Right aligns the characters that follow. |
Sheet |
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 |
---|---|
Align |
Gets or sets a value indicating whether the header or footer edges should be aligned with page margins. |
Different |
Gets or sets a value indicating whether the first page of the worksheet has unique headers and footers. |
Different |
Gets or sets a value indicating whether the odd-numbered pages have headers and footers different from those on even-numbered pages. |
Even |
Gets or sets the text to be displayed in the footer of even-numbered pages. |
Even |
Gets or sets the text to be displayed in the header of even-numbered pages. |
First |
Gets or sets the text to be displayed in the footer of the first worksheet page. |
First |
Gets or sets the text to be displayed in the header of the first worksheet page. |
Odd |
Gets or sets the text to be displayed in the footer of odd-numbered pages. |
Odd |
Gets or sets the text to be displayed in the header of odd-numbered pages. |
Scale |
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 |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
From |
Specifies the left-aligned, centered and right-aligned text for the header of footer. |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
To |
Returns a string that represents the current object. Inherited from Object. |
See Also