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

Volver arriba

Este contenido no está disponible en el idioma seleccionado.

19.10. Headers and footers

Aprender

Pruebe, compre y venda

Comunidades

Acerca de la documentación de Red Hat

Hacer que el código abierto sea más inclusivo

Acerca de Red Hat

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links