19.10. Headers and footers


Headers and footers are children of worksheets, and contain facets, which contain strings to be parsed as commands.
Expand
<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.
Expand
<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:
Expand
#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>
Copy to Clipboard Toggle word wrap
Back to top
Red Hat logoGithubredditYoutubeTwitter

Learn

Try, buy, & sell

Communities

About Red Hat Documentation

We help Red Hat users innovate and achieve their goals with our products and services with content they can trust. Explore our recent updates.

Making open source more inclusive

Red Hat is committed to replacing problematic language in our code, documentation, and web properties. For more details, see the Red Hat Blog.

About Red Hat

We deliver hardened solutions that make it easier for enterprises to work across platforms and environments, from the core datacenter to the network edge.

Theme

© 2025 Red Hat