Solved

transferring table to excel

Posted on 2004-08-19
4
298 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 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
xjc and jaxb 2 95
Display current date,month,and year to JTextField 3 63
mask rule in struts validation.xml 5 99
spring example non maven 4 100
While it may be true that the internet is a place of possibilities, it is also a hostile environment lurking with many dangers. By clicking on the wrong link, trusting the wrong person or using a weak password, you are virtually inviting hackers to …
Originally, this post was published on Monitis Blog, you can check it here . Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

696 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