Create an excel file for users to download using Apache POI

by

Do the job in a normal servlet instead of a JSP file. A JSP file is meant for dynamically generating HTML code and is using a character writer for that instead of a binary output stream and would thus only corrupt your POI-generated Excel file which is in essence a binary stream.

So, basically all you need to do in the doGet() method of the servlet is the following:

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=filename.xls");
HSSFWorkbook workbook = new HSSFWorkbook();
// ...
// Now populate workbook the usual way.
// ...
workbook.write(response.getOutputStream()); // Write workbook to response.
workbook.close();

Now, to download it, invoke the servlet by its URL instead of the JSP file.

More Related Contents:

  1. Prevent user from seeing previously visited secured page after logout
  2. How to install JSTL? The absolute uri: http://java.sun.com/jstl/core cannot be resolved
  3. Java / Jakarta EE web development, where do I start and what skills do I need? [closed]
  4. RequestDispatcher.forward() vs HttpServletResponse.sendRedirect()
  5. Populating cascading dropdown lists in JSP/Servlet
  6. Hidden features of JSP/Servlet [closed]
  7. How to differ sessions in browser-tabs?
  8. How to use relative paths without including the context root name?
  9. Passing an object from JSP page back to Servlet
  10. How do I call a specific Java method on a click/submit event of a specific button in JSP?
  11. Collect and save submitted values of multiple dynamic HTML inputs back in servlet
  12. How to transfer data from JSP to servlet when submitting HTML form
  13. How to pass Unicode characters as JSP/Servlet request.getParameter?
  14. Difference between JSP forward and redirect [duplicate]
  15. Pass variables from servlet to jsp
  16. java.lang.LinkageError: javax.servlet.jsp.JspApplicationContext.getExpressionFactory
  17. Filling HTML dropdown list in JSP with values fetched from database in Servlet
  18. How to call servlet through a JSP page
  19. How to configure welcome file list in web.xml
  20. Differences between cookies and sessions?
  21. How to send redirect to JSP page in Servlet
  22. Java Front Controller [duplicate]
  23. File upload with ServletFileUpload’s parseRequest? [duplicate]
  24. Authenticating the username, password by using filters in Java (contacting with database)
  25. Get request URL in JSP which is forwarded by Servlet
  26. Servlet send response to JSP
  27. Unicode characters in servlet application are shown as question marks
  28. How does server prioritize which type of web.xml error page to use?
  29. There is no Action mapped for namespace [/] and action name [login] associated with context path [/Struts2Test]
  30. java.lang.NoClassDefFoundError: javax/servlet/jsp/tagext/TagLibraryValidator

Leave a Comment