Hi there,
I am trying to export to excel using the display tag library.
The data displays fine. However, when I click "Excel" export, it creates an excel file with the html code for the entire page but the data part is cut off.
QUESTION: using display tag library, how do I export only the table ( including the entire list regardless of paging) being displayed and not the entire html source for the page?
Appreciate all suggestions. Thanks!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
It's hard to offer general advice without seeing the example code which is breaking.
Posted the code you are using (the key parts of it anyway, including required configuration settings), and perhaps part of the example wrong results.
Have you checked your configuration, and the display tag documentation?
http://displaytag.sourcefo
TomasHeigl > did you mean to set this in the displaytag.properties file or the web.xml? I tried it in the displaytag.properties but the wrong export still occured.
mrcoffee365:
There is no "problem" code as there are no exceptions ever thrown. When trying to export, the export occurs "successfully" BUT instead of the data being exported, the html for the page is inserted into the excel file.
--- displaytag.properties ---
sort.amount=list
export.banner=<div align="left">Export to: {0}</div>
export.types=excel
export.excel=true
export.csv=false
export.xml=false
export.excel.filename=repo
export.amount=list
export.decorated=false
Everyhing works fine except that the export produces the wrong output.
Expected: the data display in the table using the display tag library should be exported
Actual: the actual html source for the entire page is being exported BUT without the data table.
Is there anywhere else that explicit export setup needs to be done?
web.xml contains the export filter as given on Source Forge
displaytag.properties is as shown in comment above
In the JSP:
<display:table name="${sessionScope.data}
<display:column property="m_SalesLeadId" title="ID" class="fw_cssTableRow" headerClass="fw_csstableHe
<display:column property="m_CustCompanyNm"
</display:table>
Any suggestions for the cause of the data being exported incorrectly? All suggestions welcome! Thanks :o)
Did you specify the override filter in web.xml? See documentation below:
http://displaytag.sourcefo
http://displaytag.sourcefo
In that case, it sounds as if you have the configuration set up correctly. Have you checked your logs for exceptions?
If you do not find any exceptions, and the page produced does not give you any errors, just HTML with your desired spreadsheet data, then we cannot debug further without more information. If you post the code which produces the page, and the resulting page, then we might be able to get further.
In reading the displaytag forum, and other comments about Tiles, it seems clear that there are often problems producing an Excel file with the Tiles layer. It might be that you will have to debug the Tiles code itself, or create the export page as a direct link to the JSP page rather than using Tiles.
It's good that it works in JSP, so you have a workaround. I often find that the tag libraries have to be modified to do a specific task (although this is probably an actual bug, and not just a customization requirement). There are a lot of benefits to open source products, but for the new tools, the extra debugging they require is the downside.
Business Accounts
Answer for Membership
by: cs_chick99Posted on 2007-10-12 at 13:29:23ID: 20068904
Increasing the points due to time crunch urgency