How to make excel export using display tag library export my list/table? : export, excel, display, tag, using

May 17, 2008 06:15am pdt

1. rrz@871311 13,600
2. araim 6,000
3. mohammedf 4,700
4. objects 4,200
5. summerian 4,000
6. cmalakar 3,800
7. asanga_su 3,075
8. hielo 3,000
9. contactk... 2,900
10. boonleng 2,300
11. TimYates 2,000
11. gambit_642 2,000
11. Ajay-Singh 2,000
11. Howie_Ly 2,000
11. ADSLMark 2,000
11. gnoon 2,000
11. julianH 2,000
11. b0lsc0tt 2,000
11. drazen_n... 2,000
11. JSase 2,000

1. bloodredsun 140,641
2. rrz@871311 73,705
3. objects 61,382
4. boonleng 46,950
5. TimYates 39,703
6. mrcoffee365 23,650
7. actonwang 22,124
8. suprapto45 21,923
9. kennethxu 20,855
10. CEHJ 15,973
11. Kuldeepc... 14,922
12. jaggernat 13,900
13. evnafets 10,616
14. karanw 10,480
15. mayankeagle 7,660

10.12.2007 at 10:40AM PDT, ID: 22890152

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.4

How to make excel export using display tag library export my list/table?

Zones: Java Standard Tag Library (JSTL) & Server Tags, Java Server Pages (JSP), Open Source Programming

Tags: export, excel, display, tag, using

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!

Start your free trial to view this solution

Question Stats

Zone: Programming

Question Asked By: cs_chick99

Solution Provided By: mrcoffee365

Participating Experts: 2

Solution Grade: B

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

10.12.2007 at 01:29PM PDT, ID: 20068904

cs_chick99:

Increasing the points due to time crunch urgency

10.12.2007 at 10:10PM PDT, ID: 20070280

Rank: Guru

mrcoffee365:

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.sourceforge.net/11/export.html

10.15.2007 at 03:42AM PDT, ID: 20076908

TomasHelgi:

Hi!

In your web.xml config for the display tag lib try to change
export.decorated from true to false.

Regards,
Tomas Helgi

10.15.2007 at 05:55PM PDT, ID: 20082520

cs_chick99:

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=report.xls
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?

10.15.2007 at 06:00PM PDT, ID: 20082537

cs_chick99:

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}" class="fw_cssTable" id="leadsData" sort="list" export="true" pagesize="10" requestURI="/viewReports.do">
<display:column property="m_SalesLeadId" title="ID" class="fw_cssTableRow" headerClass="fw_csstableHeader" sortable="true" />
<display:column property="m_CustCompanyNm" title="Company name" class="fw_cssTableRow" headerClass="fw_csstableHeader" />
</display:table>

Any suggestions for the cause of the data being exported incorrectly? All suggestions welcome! Thanks :o)

10.15.2007 at 06:11PM PDT, ID: 20082568

cs_chick99:

UPDATE: I realized that this error appears to be caused due to using Tiles.

When I go to my tiled page, the export doesn't work properly.
When I go directly to the jsp which contains the display tag, it xports correctly.

Any suggestions please?

10.16.2007 at 06:01AM PDT, ID: 20085073

Rank: Guru

mrcoffee365:

Did you specify the override filter in web.xml? See documentation below:
http://displaytag.sourceforge.net/11/export_filter.html
http://displaytag.sourceforge.net/11/displaytag/apidocs/index.html?org/displaytag/filter/ResponseOverrideFilter.html

10.16.2007 at 06:52AM PDT, ID: 20085503

cs_chick99:

mrcoffee365: yes I have specified the override filter in my web.xml...

10.16.2007 at 08:20AM PDT, ID: 20086319

Rank: Guru

mrcoffee365:

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.

Accepted Solution

cs_chick99

10.26.2007 at 03:15PM PDT, ID: 20159432

The problem is with Tiles. Without using Tiles it works as per mrcoffee365's suggestion. Otherwise, I was unable to find a solution to use Tiles and have the excel export work.

mrcoffee365

10.26.2007 at 04:09PM PDT, ID: 20159699

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.

20080206-EE-VQP-25 / EE_QW_2_20070628