日志文章

2008年01月02日 09:37:47

用java在IE中打开Excel

[list=1]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);  
  • }  
    •  
  • }

    • Tags： IE中打开Excel  

    类别： 学习心得 |  评论(0) |  浏览(2672) |  收藏
    发表评论