FlexCel Studio for VCL/LCL
ContentsIndex
PreviousUpNext
TFlexCelImport.PageHeader Property

Header to print on each page.

Pascal
property PageHeader: UTF16String;
C++
__property UTF16String PageHeader;

Accessing this property you can read/set the page header for the active sheet. 

 

The page header has 3 sections, one at the left, one centered and one at the right. 

 

The left section begins with "&L", the centered section with "&C" and the right section with "&R" 

 

For example, to write "bye" on the left section and "hello" on the right section, you would assign a string "&Lbye&RHello" to the header. 

 

You can also insert personalized codes, for example to write the date of printing. Some of them are:

Value 
Meaning 
&P 
Current Page 
&N 
Page Count 
&D 
Date 
&T 
Time 
&F 
FileName 
&Z 
FilePath (Only Excel XP) 
&A 
Label (Sheet Name) 
&Number 
Font size. (For example, &22 is a 22 dots font) 
&"FontName" 
Font name (For example &"Arial" changes to font arial) 
&U 
Underline 
&E 
Double underline 
&S 
Overstrike 
&Y 
Subindex 
&X 
Superindex 

 

You can easily know what codes you need by studying an existing sheet. Create a sheet on Excel, set the header to whatever you want, and use the code on the first example to read the resulting string.

Copyright (c) 2002-2008 TMS Software. All rights reserved.
What do you think about this topic? Send feedback!