easypoi操作excel表格导出

1.maven坐标

<dependency>
     <groupId>cn.afterturn</groupId>
     <artifactId>easypoi-base</artifactId>
     <version>3.1.0</version>
 </dependency>
 <dependency>
     <groupId>cn.afterturn</groupId>
     <artifactId>easypoi-web</artifactId>
     <version>3.1.0</version>
 </dependency>
 <dependency>
     <groupId>cn.afterturn</groupId>
     <artifactId>easypoi-annotation</artifactId>
     <version>3.1.0</version>
 </dependency>
           

2.代码

@RequestMapping("/export")
@Controller
public class ExportExcelDemoController
{
    @GetMapping("/excel")
    public void exportExcel(HttpServletResponse response)
    {
        System.err.println("开始进行导出=============");
        @Data
        class Student
        {
            @Excel(name = "姓名", orderNum = "1", width = 18)
            private String name;
            @Excel(name = "年龄", orderNum = "2", width = 18)
            private int age;
            @Excel(name = "性别", orderNum = "3", width = 18)
            private String sex;
        }

        ArrayList<Student> studentList = Lists.newArrayList();

        Student student1 = new Student();
        student1.setAge(18);
        student1.setName("杨过");
        student1.setSex("男");

        Student student2 = new Student();
        student2.setAge(19);
        student2.setName("小龙女");
        student2.setSex("女");

        Student student3 = new Student();
        student3.setAge(40);
        student3.setName("丘处机");
        student3.setSex("男");

        studentList.add(student1);
        studentList.add(student2);
        studentList.add(student3);

        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("班级学生名册", "班级学生名册"), Student.class, studentList);
        response.setCharacterEncoding("UTF-8");
        response.setHeader("content-Type", "application/vnd.ms-excel");
        response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("班级学生名册.xls", "UTF-8"));
        workbook.write(response.getOutputStream());
    }
           

3.结果