Hi,
I am trying to use the DisplayTag export to excel / csv feature. I am using Spring and Tiles. According to the DisplayTag documentation, I have followed the process recommended and implemented the filter to support tiles. I can view the data. However, the "Export to Excel" button does not work.
In my
JSP, I have a search button and based on the input, a list is returned to the same JSP and rendered in a table. When I click on the "Export" button, it returns to the same page but now the table data is no longer visible and the export feature also doesnt work. On the logs, I dont see any exception but I see this message -
ExportDelegate, DEBUG, org.displaytag.filter.ExportDelegate: Filter is enabled but exported content has not been found. Maybe an error occurred?
My web.xml has the following-
<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>
<taglib-uri>http://displaytag.sourceforge.net/</taglib-uri>
<taglib-location>/WEB-INF/displaytag-12.tld</taglib-location>
</taglib>
JSP has the following pertaining to displaytag -
<display:table name="command.searchList" id="row" requestURI="/search.do" export="true">
<display:column property="dept" title="Department" media="html csv excel xml"/>
<display:column property="emp" title="Employess" media="html csv excel xml"/>
<display:column property="salary" title="Salary" format="$ {0,number,0,000.00}" media="html csv excel xml"/>
<display:setProperty name="css.tr.even" value="cuesTableRowEven" />
<display:setProperty name="css.tr.odd" value="cuesTableRowOdd" />
</display:table>
- where search.do is the action invoked to render this jsp
In displaytag.properties -
export.types=excel
export.excel=true
export.excel.class=org.displaytag.export.excel.DefaultHssfExportView
export.excel.include_header=true
Problem is that I dont see any exceptions, its just that the export feature just doesnt work. I'd really appreciate if anyone can help out.
Thanks.