SpreadsheetInputOptions.RenderCenterHeader Property

Definition

Gets or sets the center header to be rendered. See remarks in docs for possible script and format codes.

public string RenderCenterHeader { get; set; }

The following special script and format codes can be included as a part of the header and footer properties:

Script code	Description
&D	Prints the current date.
&T	Prints the current time.
&F	Prints the name of the document.
&A	Prints the name of the workbook tab (worksheet name).
&P	Prints the page number.
&P+number	Prints the page number plus the specified number. E.g. &P+1
&P-number	Prints the page number minus the specified number.E.g. &P-1
&&	Prints a single ampersand.
&N	Prints the total number of pages in the document.
&Z	Prints the file path.

Format code	Description
&E	Turns double-underline printing on or off.
&X	Turns superscript printing on or off.
&Y	Turns subscript printing on or off.
&B	Turns bold printing on or off.
&I	Turns italic printing on or off.
&U	Turns underline printing on or off.
&S	Turns strike-through printing on or off.
&"font-name"	Prints the characters that follow in the specified font. Be sure to include the double quotation marks. E.g. &"Arial", &"Arial,Bold"
&nn	Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. E.g. &14
&color	Prints the characters in the specified color. User supplies a hexadecimal color value. E.g. &FF0000 (red)