JSP + Excel

[volcano]

Hi, I would like to write a JSP page which will launch Excel program to report data from Oracle. I know that I can specify the header
<%@page language=&quot;java&quot; contentType=&quot;application/vnd.ms-excel&quot; %>
so that the page will become Excel format. But I find it only shows simple page layout. May I ask if it's possible to show more than one sheet in the page and show graphs in sheets? Thanks!

 

[palbano]

>> May I ask if it's possible to show more than one sheet
>> in the page and show graphs in sheets? Thanks!

Yes it is. There are several ways to do that. Perhaps the simplest is to use the XML data interface for excel. You can write XML that excel will process into sheets including multiple sheets. There was a discussion in the past few months in the XML forum about just that. You might be able to find it using the Keyword Search mechanism. Although I personally find the results questionable.

Also there are pure Java objects that encapsulate Excel spreadsheet manipulation. They are provided by the Apache group Jakarta project. The product name is POI and can be found at

http://www.apache.org

under the Jakarta project.


-pete

 

[volcano]

Hi, could you please tell me where the discussion is? I searched for the XML forum but got few results and seemed to be none of them relating to my question.

Thank you!

 

[palbano]

click here: thread426-536425

-pete

 

[volcano]

got it, thanks!