java：Excel操作之Excel下载导出

1、下载所需要的jar包

2、创建servlet命名为DownloadServlet，请求url为DownloadServlet；

public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        response.setCharacterEncoding("UTF-8");

        List<Student> list = new ArrayList<Student>();
list.add(new Student(111, "张三", 20));
list.add(new Student(112, "李四", 21));
list.add(new Student(113, "王五", 22));
list.add(new Student(114, "斯柯达", 23));
list.add(new Student(115, "收到了", 24));
list.add(new Student(116, "啦看是", 25));
list.add(new Student(117, "撒旦", 26));

//获取缓存路径
        String path = this.getServletContext().getRealPath("\\");
        path = path+"student.xls";
        Vector<Student> v = new Vector<Student>();
for (int i = 0; i < list.size(); i++) {
            v.add((Student) list.get(i));
        }
        exportExcel(path, v);
// 下载本地文件
        String fileName = "学生student.xls".toString(); // 文件的默认保存名
// 读到流中
        InputStream inStream = new FileInputStream(path);// 文件的存放路径
// 设置输出的格式
        response.reset();
        response.setContentType("bin");
//将字符串转成ios8859-1可以解决中文乱码的问题。
        response.addHeader("Content-Disposition", "attachment; filename=\"" + new String(fileName.getBytes(), "iso8859-1") + "\"");
// 循环取出流中的数据
        byte[] b = new byte[100];
int len;
try {
while ((len = inStream.read(b)) > 0)
                response.getOutputStream().write(b, 0, len);
            inStream.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

3、数据封装 将数据封装到excel中

/**
 * 数据封装 将数据封装到excel中
 * 
 * @param fileName 
 * 文件位置
 * @param content 
 * 数据列表
 */
public static void exportExcel(String fileName, Vector<Student> content) {
        WritableWorkbook wwb;
        FileOutputStream fos;
try {
            fos = new FileOutputStream(fileName);
            wwb = Workbook.createWorkbook(fos);
            WritableSheet ws = wwb.createSheet("学生名单", 10); // 创建一个工作表

// 填充数据的内容
            Student[] p = new Student[content.size()];
for (int i = 0; i < content.size(); i++) {
                p[i] = (Student) content.get(i);
                ws.addCell(new Label(0, i + 1, i + ""));
                ws.addCell(new Label(1, i + 1, p[i].getId() + ""));
                ws.addCell(new Label(2, i + 1, p[i].getName()));
                ws.addCell(new Label(3, i + 1, p[i].getAge() + ""));
if (i == 0) {
//填充表头信息
                    ws.addCell(new Label(0, i, "序号"));
                    ws.addCell(new Label(1, i, "学号"));
                    ws.addCell(new Label(2, i, "姓名"));
                    ws.addCell(new Label(3, i, "年龄"));
                }
            }
            wwb.write();
            wwb.close();
        } catch (Exception e) {

        }
    }

4、index.jsp页面请求，可忽略。直接浏览器输入请求地址。

 <form action="DownloadServlet" method="post">
      <input type="submit" value="下载Excel">
    </form>

5、效果

Demo源代码下载：https://www.yangjiace.xyz/