This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Servlets and the fly likes outputing a jsp page in excel format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "outputing a jsp page in excel format" Watch "outputing a jsp page in excel format" New topic

outputing a jsp page in excel format

deepa mc

Joined: Feb 25, 2003
Posts: 1
I set the content type of my jsp page to ms-excel and it is opening in excel too , but i don't see the rows and columns..i see it only after i change the format cells of the ms-excel ..Is there any way i could see it as soon as i see the excel page without manually formatting it?
Thanks in advance,
Ruilin Yang
Ranch Hand

Joined: Jan 06, 2002
Posts: 150
It looks like you need to put the format inf. when you call the excel.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 60767

If you output the data as an HTML table, Excel will interpret it as the rows and columns of the spreadsheet.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Trish Wu
Ranch Hand

Joined: Oct 09, 2002
Posts: 34
You can also try and use Jakarta POI.
I agree. Here's the link:
subject: outputing a jsp page in excel format
Similar Threads
Opening an Excel file
More... on how to generate output from "jsp to excel"
Database output results to Excel
Exporting data from Mozilla to MsExcel
display output table in excel file format