Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JExcel API can't output file from a servlet

807589Jul 25 2007 — edited Oct 2 2008
import java.io.IOException;
	import java.io.OutputStream;
	 
	import javax.servlet.ServletException;
	import javax.servlet.http.HttpServlet;
	import javax.servlet.http.HttpServletRequest;
	import javax.servlet.http.HttpServletResponse;
	 
	import jxl.Workbook;
	import jxl.write.Label;
	import jxl.write.WritableSheet;
	import jxl.write.WritableWorkbook;
	 
	public class Sample extends HttpServlet
	{
	 public void doGet(HttpServletRequest request, HttpServletResponse response)
	 throws ServletException, IOException
	 {
	  OutputStream out = null;
	  try
	  {
	   response.setContentType("application/vnd.ms-excel");
	   response.setHeader("Content-Disposition", "attachment; filename=sampleName.xls");
	   WritableWorkbook w = Workbook.createWorkbook(response.getOutputStream());
	   WritableSheet s = w.createSheet("Demo", 0);
	   s.addCell(new Label(0, 0, "Hello World"));
	   w.write();
	   w.close();
	  } catch (Exception e)
	  {
	   throw new ServletException("Exception in Excel Sample Servlet", e);
	  } finally
	  {
	   if (out != null)
	    out.close();
	  }
	 }
	}
I am trying to create a generic class that can export database table to excel files. But the problem is Workbook.createWorkbook(OuputStream) only take in outputstream. I can't pass the outputstream over to servlet for the user to download.

Anyone can help?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2008
Added on Jul 25 2007
4 comments
966 views