generating excel sheets

[sreedhar somisetty]

using servlets how can i set the content into excel sheets.i want to set the content into two wroksheets in the same excel?
[ May 11, 2006: Message edited by: Ben Souther ]

[Christophe Verré]

I don't think that this has something to do with servlets.
You should search about the POI library at Jakarta:
http://jakarta.apache.org/poi/index.html

[Ben Souther]

sreedhar somisetty,

Welcome to JavaRanch.
To help you get the most out of our forums, we have compiled a list of tips for asking questions here. You can find this list here.

In particular, please see: UseAMeaningfulSubjectLine.
All the questions in a servlet forum are expected to be related to servlets so using 'servlets' as your subject line doesn't really give any hints as to the nature of your question.

[Anupam Sinha]

Use jexcel. Its much better than POI. You can find jexcel at Andy Khans's JExcel.

[Anonymous]

Another possibility is to use xml spreadsheet:

This is a xml format created by microsoft that describe a excel sheet and can be open and saved by excell.

to send back an excel file *.xls or a spreadsheet *.xml from a servlet

if content is a byte[] with your excell file just push it

response.reset();
response.setContentType("application/vnd.ms-excel");
response.setContentLength(content.length);
response.setBufferSize(content.length);
response.getOutputStream().write(content);
response.getOutputStream().flush();