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.

Torna in cima

Questo contenuto non è disponibile nella lingua selezionata.

19.5. Columns

Formazione

Prova, acquista e vendi

Community

Informazioni sulla documentazione di Red Hat

Rendiamo l’open source più inclusivo

Informazioni su Red Hat

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links