|
FlexCel Studio for VCL/LCL
|
Header to print on each page.
property PageHeader: UTF16String;
__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!
|