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.

Expand

<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>

 
<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>

Copy to Clipboard

Toggle word wrap

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

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

19.5. Columns

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