用浏览器打开Excel文件的Java程序

最新推荐文章于 2023-11-28 06:56:46 发布

clarebaby504

最新推荐文章于 2023-11-28 06:56:46 发布

阅读量4.6k

点赞数

分类专栏： java

java 专栏收录该内容

23 篇文章

订阅专栏

本文介绍了一个使用Java Servlet实现Excel文件直接在浏览器中打开或下载的例子。通过设置MIME类型为application/vnd.ms-excel并配置Content-disposition头来指定文件名及打开方式，实现了从服务器端直接提供Excel文件的功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public class TestOpenExcel extends HttpServlet { private static final String url = D:/test.xls; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { /** * setContentType设置M-   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); } }-
    }  
     
    protected void doPost(HttpServletRequest request,   
      HttpServletResponse response) throws ServletException, IOException {   
     doGet(request, response);   
    }   
     
   }