poI导excel

1.pom.xml

<!--poi进行excel操作-->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.15</version>
</dependency>

2.contorller

//导出excel
@RequestMapping("export")
public String export(Model model,HttpServletResponse response) throws  Exception{

    // 定义表的标题
    String title = "用户列表一览";
    //定义表的列名
    String[] rowsName = new String[] { "用户ID","用户名", "密码", "年龄", "性别","头像","爱好"};
    //定义表的内容
    List<Object[]> dataList = new ArrayList<Object[]>();
    Object[] objs= null;
    List<User> listPerson = dao.selectUser();
    for (int i = 0; i < listPerson.size(); i++) {
        User user = listPerson.get(i);
        objs = new Object[rowsName.length];
        objs[0] = user.getId();
        objs[1] = user.getName();
        objs[2] = user.getPassword();
        objs[3] = user.getAge();
        objs[4] = user.getSex();
        objs[5] = user.getHead();
       objs[6] = user.getHappy();

        dataList.add(objs);
    }
    // 创建ExportExcel对象
    ExportExcel ex = new ExportExcel(title, rowsName, dataList);
    // 输出Excel文件
    try {
        OutputStream output =   response.getOutputStream();
        response.reset();

        response.setContentType("application/vnd.ms-excel;charset=utf-8");
        response.setHeader("Content-Disposition", "attachment;filename="
                +  "userList.xls");
        ex.export(output);
        output.close();
    } catch (IOException e) {
        e.printStackTrace();
    }

    return null;
}

3工具类