Solved

transferring table to excel

Posted on 2004-08-19
4
295 Views
Last Modified: 2010-04-01

I have an HTML table as an output, i want to export the table contents to excel, is it possible?
i am using to JSP with tomcat.
0
Comment
Question by:richard234
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
thomas908 earned 450 total points
ID: 11849383
You may try

<%@ page contentType="application/vnd.ms-excel" %>

in your JSP page.

But his way you may not be able to have complete control over data

 That is just there to allow a easy way to convert table into a simple excel sheet.  If you want more control over the data, you may use POI:

http://jakarta.apache.org/poi/

0
 

Author Comment

by:richard234
ID: 11849403
I basically need to manipulate print options like

Orientation automatically selected as Landscape.
Scaling fit to one window.
Margin left 0.00

Will this help me?
0
 
LVL 8

Expert Comment

by:thomas908
ID: 11849406
Yes POI will but NOT contentType.

Here is some additional reference how to set up print options:
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFPrintSetup.html
0
 

Expert Comment

by:Balaji108
ID: 13549940
required urgently sample code forExport to Excel for a jsp struts application.

thanks.
BR
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Mockito Method call failing. 3 189
password protect pdf 11 74
hashcode is calculated on the basis of value object 2 103
runtime exception and error differences 4 72
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now