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>

 
<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

Ce contenu n'est pas disponible dans la langue sélectionnée.

19.10. Headers and footers

Apprendre

Essayez, achetez et vendez

Communautés

À propos de la documentation Red Hat

Rendre l’open source plus inclusif

À propos de Red Hat

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links