Solved

transferring table to excel

Posted on 2004-08-19
4
299 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

695 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