java下载excel示例_使用POI进行Excel文件下载的示例工程

packagecom.heyang.action;importjava.io.BufferedOutputStream;importjavax.servlet.ServletException;importjavax.servlet.ServletOutputStream;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importcom.heyang.service.DownloadService;/*** POI下载的Servlet

*@authorheyang

**/publicclassDownloadServletextendsHttpServlet {privatestaticfinallongserialVersionUID=56890894234786L;publicvoiddoPost(HttpServletRequest request, HttpServletResponse response)throwsServletException, java.io.IOException {

String fileName="download.xls";

response.setHeader("Content-disposition","attachment; filename="+fileName);//设定输出文件头response.setContentType("application/msexcel");//定义输出类型try{introwCount=Integer.parseInt(request.getParameter("rowCount"));//表头行Str