?
Solved

transferring table to excel

Posted on 2004-08-19
4
Medium Priority
?
301 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
thomas908 earned 1800 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

762 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