Hello,
I would appreciate it if anyone could help me get this right; i have spent
hours trawling the mailing lists and think i know the way, but doesnt appear to
be working. We are using displatTag v1.2, and I get this wierd error when
trying to use the DefaultHssfExportView in my JSP:
Exception: [.DefaultHssfExportView] !DefaultHssfExportView.errorexporting!
Cause: The 'to' row (0) must not be less than the 'from' row (26)
at
org.displaytag.export.excel.DefaultHssfExportView.doExport(DefaultHssfExportView.java:54)
My requirement is to get column totals displayed in the exported Excel sheet
from one particular displayTable in our webapp (out of multiple displayTables).
Here is what I have done so far:
1) configured displaytag.properties like so:
export.types=csv excel xml rexcel
export.csv=false
export.excel=false
export.rexcel=false
export.rexcel.class=org.displaytag.export.excel.DefaultHssfExportView
2) Added the displaytag-export-poi v1.2 jar as a dependency in my maven pom.
3) in the one JSP where i want the column totals to be exported, I have
configured the displayTable like so:
<display:table id=".." name="sessionScope..."
export="true"
sort="list" uid=".." defaultorder="descending" defaultsort="0"
pagesize="${sessionScope.pageSize}" cellspacing="0"
cellpadding="0"
requesturi=".....do">
<display:column ....media="rexcel">
<display:setProperty name="export.rexcel" value="true" />
<display:setProperty name="export.excel" value="false" />
<display:setProperty name="export.rexcel.include_header"
value="true" />
<display:setProperty name="export.rexcel.filename"
value="Adjustments.xls" />
<display:setProperty name="export.rexcel.label">
<img src='${contextPath}/images/icon_export_excel.jpg'
border='0' alt='export'/> Excel
</display:setProperty>
Could someone please tell me if I am using the right configuration? I have been
stuck here for a while, so any help is most appreciated!
Thanks,
Vik.
_________________________________________________________________
Windows Live™ Groups: Create an online spot for your favorite groups to meet.
http://windowslive.com/online/groups?ocid=TXT_TAGLM_WL_groups_032009------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
