How can I output an Excel work book with multiple sheets in it from Servlet or JSP
use the great Jexcel API:
Java Excel API is a mature, open source java API enabling developers to read, write, and modifiy Excel spreadsheets dynamically. Now java developers can read Excel spreadsheets, modify them with a convenient and simple API, and write the changes to any output stream (e.g. disk, HTTP, database, or any socket).
http://www.nelcom.ch (J2EE in Ticino, Switzerland)
Hii How can I output an Excel work book with multiple sheets in it from Servlet or JSPThankxShojApache Jakarta POI project is the ultimate answer. Even 10 lines of code can do magic with Apache POI. Sorry if I sound biased, but I was thrilled when I used it.