Aspose::Cells::PageSetup::SetHeader method

PageSetup::SetHeader(int32_t, const U16String&) method

Sets a script formatting the header of an Excel file.

void Aspose::Cells::PageSetup::SetHeader(int32_t section, const U16String &headerScript)
ParameterTypeDescription
sectionint32_t0: Left Section, 1: Center Section, 2: Right Section.
headerScriptconst U16String&Header format script.

Remarks

Script commands:

CommandDescription
&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"
&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.
&KFont color, for example(RED): &KFF0000
&GImage script
For example: "&Arial,Bold&8Header Note" ## See Also

PageSetup::SetHeader(int32_t, const char16_t*) method

Sets a script formatting the header of an Excel file.

void Aspose::Cells::PageSetup::SetHeader(int32_t section, const char16_t *headerScript)
ParameterTypeDescription
sectionint32_t0: Left Section, 1: Center Section, 2: Right Section.
headerScriptconst char16_t*Header format script.

Remarks

Script commands:

CommandDescription
&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"
&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.
&KFont color, for example(RED): &KFF0000
&GImage script
For example: "&Arial,Bold&8Header Note" ## See Also