实体类
package com.wangling.domain;
import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
/**
* id
*/
@Excel(name = "学生id")
private String id;
/**
* 学生姓名
*/
@Excel(name = "学生姓名")
private String name;
/**
* 学生性别
*/
@Excel(name = "学生性别")
private int sex;
}
生成excel的代码
import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.wangling.SpringTestStart;
import com.wangling.domain.Student;
import org.apache.poi.ss.usermodel.Workbook;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.junit4.SpringRunner;
import java.io.File;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@SpringBootTest(classes = SpringTestStart.class)
@RunWith(SpringRunner.class)
public class ExcelTest {
@Test
public void test()throws Exception{
List<Student> list=new ArrayList<>();
list.add(new Student("1","zs",1));
list.add(new Student("2","ls",1));
list.add(new Student("3","ww",1));
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("计算机一班","学生"),Student.class,list);
workbook.write(new FileOutputStream(new File("E:/student.xlsx")));
workbook.close();
}
}
workbook.write(new FileOutputStream(new File("E:/student.xlsx")));
由于这里导出是xlsx文件,导出的时候要考虑兼容性,只要把这里的导出的文件改为xls文件,因为xlsx向下兼容xls所以直接就能打开成功
workbook.write(new FileOutputStream(new File("E:/student.xls")));