使用poi 打开excel

最新推荐文章于 2025-06-30 00:44:22 发布

原创最新推荐文章于 2025-06-30 00:44:22 发布 · 948 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#import #variables #url #excel #resources #string

java 专栏收录该内容

8 篇文章

订阅专栏

本文提供了一个使用Java实现的简单示例，演示了如何从服务器导出Excel文件到客户端浏览器，并设置了正确的响应头以便浏览器能够正确处理和显示Excel文件。

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

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.csland.common.util.*;

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class prnexcel
extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
private String url = "D:/test.xls";

//Initialize global variables
public void init() throws ServletException {
}

//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    /**
     * setContentType设置MIME类型，Acrobat
     * PDF文件为"application/pdf"，WORD文件为："application/msword"，
     * EXCEL文件为："application/vnd.ms-excel"。
     */
    //url = Consts.APP_PATH + "statistic/cw/" +
    //    StrUtil.convNull(request.getParameter("excelfile"));

    //url = "E:/ylb.xls";
    System.out.println("url=" + url);
    File file = new File(url);
    System.out.println("fileName=" + file.getName());

    response.setContentType("application/vnd.ms-excel;charset=GBK");
    /**
     * setHeader设置打开方式，具体为：inline为在浏览器中打开，attachment单独打开。
     */

response.setHeader("Content-disposition",
"inline;filename=/"" + file.getName() + "/";");

    OutputStream out = response.getOutputStream();
    POIFSFileSystem fs;
    try {
      fs = new POIFSFileSystem(new FileInputStream(url));
      HSSFWorkbook wb = new HSSFWorkbook(fs);
      HSSFSheet sheet = wb.getSheet("Sheet1");

      wb.write(out);
      out.close();
    }
    catch (IOException e) {
      e.printStackTrace();
    }

//本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/gisoracle/archive/2009/07/03/4318380.aspx

}

//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}

//Clean up resources
public void destroy() {
}
}