PageSetupSetHeader Method

Sets a script formatting the header of an Excel file.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 21.6.0.0 (21.6)
Syntax
public void SetHeader(
	int section,
	string headerScript
)

Parameters

section
Type: SystemInt32

0:Left Section.

1:Center Section

2:Right Section

headerScript
Type: SystemString
Header format script.
Remarks

Script commands:

Command¡¡Description¡¡
&PCurrent page number¡¡
&NPage count¡¡
&DCurrent date¡¡
&TCurrent time
&ASheet name
&FFile name without path
&"<FontName>"Font name, for example: &"Arial"
&"<FontName>, <FontStyle>"Font name and font style, for example: &"Arial,Bold"
&<FontSize>Font size. If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.
&"<K"Font color, for example(RED): &FF0000
&GImage script
For example: "&Arial,Bold&8Header Note"
See Also