Can not export single row to excel by using "ExcelHssfView" and
"DefaultHssfExportView"
---------------------------------------------------------------------------------------
Key: DISPL-297
URL: http://jira.codehaus.org/browse/DISPL-297
Project: DisplayTag
Type: Bug
Components: Export
Versions: After 1.1
Reporter: Wallace Mu
Priority: Minor
Attachments: testExportSingleRow.jsp
When the return resultSet just has one single row, it can not be export to
Excel.
But export to PDF, XML, CSV and RTF is OK.
I change my "export.excel.class" setting in displaytag.properties, found that :
If I use "org.displaytag.export.excel.ExcelHssfView" or
"org.displaytag.export.excel.DefaultHssfExportView", it will have this error.
If I use "org.displaytag.export.ExcelView", it can export.
If it is error, the following Exception is reported:
############################Message
begin###################################################
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from
fulfilling this request.
exception
java.lang.IllegalStateException: getOutputStream() has already been called for
this response
org.apache.catalina.connector.Response.getWriter(Response.java:606)
org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:195)
org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:124)
org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:117)
org.apache.jasper.runtime.PageContextImpl.release(PageContextImpl.java:191)
org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(JspFactoryImpl.java:115)
org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(JspFactoryImpl.java:75)
org.apache.jsp.test.displayTab.testExportSingleRow_jsp._jspService(org.apache.jsp.test.displayTab.testExportSingleRow_jsp:545)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
cn.com.cunamutual.user.SessionChecker.doFilter(SessionChecker.java:47)
filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
note The full stack trace of the root cause is available in the Apache
Tomcat/5.5.12 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.12
############################Message
end###################################################
My "displaytag.properties" is showing follow:
######################displaytag.properties
Begin############################################
#sort.behavior=list
#sort.amount=list
basic.empty.showtable=true
#basic.msg.empty_list=No results matched your criteria.
#paging.banner.placement=top
#paging.banner.onepage=<span class="pagelinks"></span>
export.types=csv excel xml pdf rtf
#export.types=excel pdf
export.excel=true
export.csv=true
export.xml=true
export.pdf=true
export.rtf=true
export.amount=list
export.excel.class=org.displaytag.export.excel.ExcelHssfView
#export.excel.class=org.displaytag.export.excel.DefaultHssfExportView
#export.excel.class=org.displaytag.export.ExcelView
export.pdf.class=org.displaytag.export.PdfView
export.rtf.class=org.displaytag.export.DefaultRtfExportView
# if set, file is downloaded instead of opened in the browser window
export.excel.filename=testExport
export.pdf.filename=testExport
export.csv.filename=testExport
export.rtf.filename=testExport
export.xml.filename=testExport
# I18N default "locale.provider" is "I18nJstlAdapter"
#locale.provider=org.displaytag.localization.I18nStrutsAdapter
#locale.provider=org.displaytag.localization.I18nJstlAdapter
######################displaytag.properties
End############################################
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
displaytag-devel mailing list
displaytag-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-devel
