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.結果