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