Hi all,

I would like to ask something about rich:datatable excel export. I can successfully export the data table as an excel file. But I would like to add a Text in first row of the excel as well. Is it possible to do that?

In this example below I tried to add Description of the Data Table centences in the first row of the excel but It didnt worked. I just got the values from rich columns.

<h:form id="excelExport">    
    <rich:dataTable rowKeyVar="rowKey" value="#{policeList.resultList}" var="police" id="policeList" width="450px" height="400px" > 
        <f:facet name="header"> 
            <h:outputText value="Description of the Data Table" /> 
        </f:facet> 
 
        <rich:column width="100px" sortable="true" filterBy="#{police.policeNo}" filterEvent="onkeyup"> 
            <f:facet name="header"> 
                <h:outputText value="Policy No" /> 
            </f:facet> 
            <h:outputText value="#{police.policeNo}" id="policeNo" /> 
        </rich:column> 
 
        <rich:column width="200px" sortable="true" filterBy="#{police.policeAdi}" filterEvent="onkeyup"> 
            <f:facet name="header"> 
                <h:outputText value="Policy Name" /> 
            </f:facet> 
            <h:outputText value="#{police.policeAdi}" id="name" /> 
        </rich:column> 
 
    </rich:dataTable>
    <h:commandButton id="exporter" type="Submit" value="Export to Excel" action="#{org.jboss.seam.excel.exporter.excelExporter.export('excelExport:policeList')}" />
</h:form>