19.10. Headers and footers

Headers and footers are children of worksheets, and contain facets, which contain strings to be parsed as commands.
<e:header>
Attributes
  • none
Child elements
  • none
Facets
  • left — The contents of the left header part.
  • center — The contents of the central header part.
  • right — The contents of the right header part.
<e:footer>
Attributes
  • none
Child elements
  • none
Facets
  • left — The contents of the left footer part.
  • center — The contents of the central footer part.
  • right — The contents of the right footer part.
Because facets contain string values, they can contain various #-delimited commands, like the following:
#date#
Inserts the current date.
#page_number#
Inserts the current page number.
#time#
Inserts the current time.
#total_pages#
Inserts the total page count.
#worksheet_name#
Inserts the worksheet name.
#workbook_name#
Inserts the workbook name.
#bold#
Toggles bold font. One use turns bold text on; a second use turns bold text off.
#italics#
Toggles italic font. One use turns italic text on; a second use turns italic text off.
#underline#
Toggles underlined font. One use turns underlined text on; a second use turns underlined text off.
#double_underline#
Toggles double-underlined font. One use turns double-underlying text on; a second use turns double-underlined text off.
#outline#
Toggles outlined font. One use turns outlined text on; a second use turns outlined text off.
#shadow#
Toggles shadowed font. One use turns shadowed text on; a second use turns shadowed text off.
#strikethrough#
Toggles struck-through font. One use turns struck-through text on; a second use turns struck-through text off.
#subscript#
Toggles subscript font. One use turns subscript text on; a second use turns subscript text off.
#superscript#
Toggles superscript font. One use turns superscript text on; a second use turns superscript text off.
#font_name#
Sets font name. To set Verdana as the font, use #font_name=Verdana#.
#font_size#
Sets font size. To set 12 as the font size, use #font_size=12#. 
 
<e:workbook> 
  <e:worksheet>
    <e:header> 
      <f:facet name="left"> 
        This document was made on #date# and has #total_pages# pages. 
      </f:facet> 
      <f:facet name="right"> #time# </f:facet> 
    </e:header> 
  <e:worksheet> 
</e:workbook>