All pastes #2076120 Raw Edit

Excel sample Seam JSF

public text v1 · immutable
#2076120 ·published 2011-06-07 11:42 UTC
rendered paste body
<html xmlns="http://www.w3.org/1999/xhtml"
      xmlns:s="http://jboss.com/products/seam/taglib"
      xmlns:excel="http://jboss.com/products/seam/excel"
      xmlns:f="http://java.sun.com/jsf/core">

    <excel:workbook type="#{exportType}"
                    excelDisplayLanguage="#{localeSelector.locale.country}"
                    excelRegionalSettings="#{localeSelector.locale.country}"
                    locale="#{localeSelector.locale.country}">
        <excel:link URL="#{excelCss}"/>
        
        <excel:worksheet name="#{messages['sales.listTotalSales']}"
                         value="#{salesTotalSearchQueryExcel.resultList}"
                         var="sales"
                         defaultRowHeight="350">
            <excel:column styleClass="autosize">
                <f:facet name="header">
                    <excel:cell value="#{messages['shop.codeSite']}"
                                styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell integer" value="#{sales.site.codeSite}"/>
            </excel:column>
            <excel:column styleClass="autosize">
                <f:facet name="header">
                    <excel:cell value="#{messages['shop.label']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell text" value="#{sales.site.label}"/>
            </excel:column>
            <excel:column styleClass="autosize">
                <f:facet name="header">
                    <excel:cell value="#{messages['period']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell text" value="#{sales.period.id}"/>
            </excel:column>
            <excel:column styleClass="autosize">
                <f:facet name="header">
                    <excel:cell value="#{messages['search.period.label']}" styleClass="header"/>
                </f:facet>
                <excel:cell
                    styleClass="cell text"
                    value="#{messages['periodtype.'.concat(sales.period.type)]}"/>
            </excel:column>
            <excel:column styleClass="date">
                <f:facet name="header">
                    <excel:cell value="#{messages['search.dateFrom']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell date" value="#{sales.period.dateBegin}"/>
            </excel:column>
            <excel:column styleClass="date">
                <f:facet name="header">
                    <excel:cell value="#{messages['search.dateTo']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell date" value="#{sales.period.dateEnd}"/>
            </excel:column>
            <excel:column styleClass="autosize">
                <f:facet name="header">
                    <excel:cell value="#{messages['customers']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell integer" value="#{sales.customers}"/>
            </excel:column>
            <excel:column styleClass="autosize">
                <f:facet name="header">
                    <excel:cell value="#{messages['exchanges']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell integer" value="#{sales.exchanges}"/>
            </excel:column>
            <excel:column styleClass="autosize">
                <f:facet name="header">
                    <excel:cell  value="#{messages['salesLead']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell integer" value="#{sales.salesLead}"/>
            </excel:column>
            <excel:column styleClass="currency">
                <f:facet name="header">
                    <excel:cell  value="#{messages['salesLeadAmount']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell currency" value="#{sales.amountSalesLead}"/>
            </excel:column>
            <excel:column styleClass="currency">
                <f:facet name="header">
                    <excel:cell  value="#{messages['sales.amount']}" styleClass="header"/>
                </f:facet>
                <excel:cell styleClass="cell currency" value="#{sales.amount}"/>
            </excel:column>
        </excel:worksheet>
    </excel:workbook>
</html>