19.5. Columns

Columns are the children of worksheets and the parents of cells, images, formulas and hyperlinks. They control the iteration of the worksheet data. See Section 19.14.5, “Column settings” for formatting.

<e:column>

Attributes

none

Child elements

<e:cell/> — Zero or more cells. (See Section 19.6, “Cells”.)
<e:formula/> — Zero or more formulas. (See Section 19.7, “Formulas”.)
<e:image/> — Zero or more images. (See Section 19.8, “Images”.)
<e:hyperLink/> — Zero or more hyperlinks (see Section 19.9, “Hyperlinks” ).

Facets

header — This facet can/will contain one <e:cell>, <e:formula>, <e:image> or <e:hyperLink>, which will be used as header for the column.
footer — This facet can/will contain one <e:cell>, <e:formula>, <e:image> or <e:hyperLink>, which will be used as footer for the column.

 
<e:workbook> 
  <e:worksheet> 
    <e:column value="#{personList}" var="person"> 
      <f:facet name="header"> 
        <e:cell value="Last name"/> 
      </f:facet> 
      <e:cell value="#{person.lastName}"/> 
    </e:column> 
  </e:worksheet> 
<e:workbook>

This defines a column with a header and an iterated output.