用java在IE中打开Excel

闲来无事做的一个小例子:

java 代码

public class TestOpenExcel extends HttpServlet {

private static final String url = "D:/test.xls";

protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {

  /**
   * setContentType设置MIME类型，Acrobat
   * PDF文件为"application/pdf"，WORD文件为："application/msword"，
   * EXCEL文件为："application/vnd.ms-excel"。
   */
  response.setContentType("application/vnd.ms-excel");
  /**
   * setHeader设置打开方式，具体为：inline为在浏览器中打开，attachment单独打开。
   */
response.setHeader("Content-disposition", "inline;filename=\"" + "test.xls"+ "\";");

  ServletOutputStream sos = response.getOutputStream();
  FileInputStream fis = new FileInputStream(url);

  BufferedOutputStream bos = new BufferedOutputStream(sos);
  byte[] bytes = new byte[8192];
  bos.write(bytes, 0, fis.read(bytes));
  fis.close();
  sos.close();
  bos.close();


 }


 protected void doPost(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  doGet(request, response);
 }

}

分享到：

struts实现上传篇 | 用java生成验证码

• 2007-02-12 09:27
• 浏览 8963
• 评论(2)
• 查看更多

评论

2 楼 wlxlz 2013-03-18  

怎么是一推乱码？

1 楼 tiantianhappy 2010-04-29  

Very good