File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "outputing a jsp page in excel format" Watch "outputing a jsp page in excel format" New topic
Author

outputing a jsp page in excel format

deepa mc
Greenhorn

Joined: Feb 25, 2003
Posts: 1
Hi,
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,
Deepa
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
Marshal

Joined: Jan 10, 2002
Posts: 60046
    
  65

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


[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: http://aspose.com/file-tools
 
subject: outputing a jsp page in excel format
 
Similar Threads
Database output results to Excel
Exporting data from Mozilla to MsExcel
display output table in excel file format
Opening an Excel file
More... on how to generate output from "jsp to excel"