首页 > 代码库 > java生成excel表格和pdf并实现下载弹出框
java生成excel表格和pdf并实现下载弹出框
今天在pdf和excel中都实现了在浏览器弹出下载框
将之前在网上查找的生成excel表格代码稍微修改下:
public class CreateSimpleExcelToDisk { /** * @功能:手工构建一个简单格式的Excel */ private static List<News> getNews() throws Exception { List<News> data = http://www.mamicode.com/new ArrayList();> 用servlet实现下载:此代码可以套用public class ExpExcelServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String fileName = "news.et"; response.setContentType("octets/stream"); response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "utf-8")); try { NewsDao dao = new NewsDao(); ArrayList<News> list = dao.queryAll(); CreateSimpleExcelToDisk ce=new CreateSimpleExcelToDisk(); OutputStream out = response.getOutputStream(); ce.ExpExcel(out); out.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } System.out.println("et导出成功!"); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request,response); } }网上的资料可以采用: 1、RequestDispatcher的方式进行; 2、采用文件流输出的方式下载。 1、采用RequestDispatcher的方式进行 jsp页面中添加如下代码: <% response.setContentType("application/x-download");//设置为下载application/x-download String filedownload = "/要下载的文件名";//即将下载的文件的相对路径 String filedisplay = "最终要显示给用户的保存文件名";//下载文件时显示的文件保存名称 filenamedisplay = URLEncoder.encode(filedisplay,"UTF-8"); response.addHeader("Content-Disposition","attachment;filename=" + filedisplay); try { RequestDispatcher dis = application.getRequestDispatcher(filedownload); if(dis!= null) { dis.forward(request,response); } response.flushBuffer(); } catch(Exception e) { e.printStackTrace(); } finally { } %> 2、采用文件流输出的方式下载 <%@page language="java" contentType="application/x-msdownload" pageEncoding="gb2312"%><% //关于文件下载时采用文件流输出的方式处理: //加上response.reset(),并且所有的%>后面不要换行,包括最后一个; response.reset();//可以加也可以不加 response.setContentType("application/x-download"); String filedownload = "想办法找到要提供下载的文件的物理路径+文件名"; String filedisplay = "给用户提供的下载文件名"; filedisplay = URLEncoder.encode(filedisplay,"UTF-8"); response.addHeader("Content-Disposition","attachment;filename=" + filedisplay); OutputStream outp = null; FileInputStream in = null; try { outp = response.getOutputStream(); in = new FileInputStream(filenamedownload); byte[] b = new byte[1024]; int i = 0; while((i = in.read(b)) > 0) { outp.write(b, 0, i); } outp.flush(); } catch(Exception e) { System.out.println("Error!"); e.printStackTrace(); } finally { if(in != null) { in.close(); in = null; } if(outp != null) { outp.close(); outp = null; } } %> 在wsad里面写JSP文件下载,总是出现这个异常,getOutputStream() has already been called for this response,输出流已经被调用了. 上网查半天终于明白一点,JSP早下载文件的时候用到了OutputStream,而在Application Server在处理编译jsp时对于%>和<%之间的内容一般是原样输出,而且默认是PrintWriter.
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。