export to excel - displaytag

[Struts User]

Hi all,

I am trying to export data to excel using diplaytag. I am able to save the
excel file but the file is empty. Any help is greatly appreciated.
I am setting the export filter and display-tag properties as below.

*web.xml:*

<filter>
        <filter-name>ResponseOverrideFilter</filter-name>

<filter-class>org.displaytag.filter.ResponseOverrideFilter</filter-class>
    </filter>

    <filter-mapping>
        <filter-name>ResponseOverrideFilter</filter-name>
        <url-pattern>*.do</url-pattern>
    </filter-mapping>
    <filter-mapping>
        <filter-name>ResponseOverrideFilter</filter-name>
        <url-pattern>*.jsp</url-pattern>
    </filter-mapping>

*displaytag.properties*

#sort.behavior=list
#sort.amount=list
basic.empty.showtable=true
basic.msg.empty_list=<b>Query returned no results.</b>
basic.msg.empty_list_row=<tr class="empty"><td colspan="{0}" ><img
alt="Warning" src="images/iconWarning.gif"/>&nbsp;<b>Query returned no
results.</b></td></tr>
#paging.banner.placement=top
#paging.banner.onepage=<span class="pagelinks"></span>
export.types=csv excel xml pdf rtf
export.excel=true
export.csv=true
export.xml=true
export.pdf=true
export.rtf=true
export.excel.class=org.displaytag.export.excel.DefaultHssfExportView
export.pdf.class=org.displaytag.export.DefaultPdfExportView
export.rtf.class=org.displaytag.export.DefaultRtfExportView
# if set, file is downloaded instead of opened in the browser window
export.excel.filename=logging_report.xls
export.excel.include_header=true

*Table.jsp*

<display:table name="lstLoggings" class="tablesorter"  id="loggings"
length="10" export="true" >
            <display:setProperty name="basic.empty.showtable"
value="false"/>
            <display:setProperty name="basic.msg.empty_list" value=""/>
             <display:setProperty name="export.excel"
value="true"></display:setProperty>
            <display:setProperty name="export.excel.filename"
value="LoggingReport.xls"></display:setProperty>

            <display:column property="noLogins" title="No. of
Logins"></display:column>
            <display:column property="sysurAutoKey" title="User
Key"></display:column>
            <display:column property="userName" title="User
Name"></display:column>
            <display:column property="emailAddress" title="Email
Address"></display:column>
            <display:column property="companyName" title="Company
Name"></display:column>
            <display:column property="companyCode" title="Company
Code"></display:column>

        </display:table>

Thanks.