Header Property

Gets or sets the header for each page of the printed worksheet.

Syntax

Visual Basic

'Declaration
 
Public Property Header As String

C#

public string Header {get; set;}

Property Value

The header for each page of the worksheet.

Remarks

The '&' character in the header and footer is a special character. Depending on what is after it, the formatting of the text can be controlled or dynamic text can be inserted. Below is a list of the available commands:

Section commands
&L	The following text will appear in the left section. The formatting of new sections is always the default formatting, regardless of the formatting of the previous section.
&C	The following text will appear in the center section. The formatting of new sections is always the default formatting, regardless of the formatting of the previous section.
&R	The following text will appear in the right section. The formatting of new sections is always the default formatting, regardless of the formatting of the previous section.

Replacement commands
&&	Insert the '&' character.
&A	Insert the current worksheet name.
&D	Insert the current date.
&F	Insert the current file name.
&G	Insert an image (Note: This command is currently not supported).
&N	Insert the number of pages the worksheet will need to print.
&P	Insert the current page number.
&T	Insert the current time.
&Z	Insert the current file path (without the file name).