POI之easypoi操作（二）

    <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>   

@Data
public class People implements Serializable{
    @Excel(name = "学生Id")
    private Integer id ;
    @Excel(name = "姓名")
    private String name ;
    @Excel(name = "学生地址")
    private String site ;
    @Excel(name = "保存日期")
    private LocalDate localDate ;
}

 People people = new People() ;
        people.setId(1);
        people.setName("abc");
        people.setSite("江西南昌");
        people.setLocalDate(LocalDate.now());
        List<People> list = new ArrayList() ;
        list.add(people) ;
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("物联一班","测试"),People.class, list) ;
        String fileName = "D:\\test.xls";
        FileOutputStream out = new FileOutputStream(fileName) ;
        workbook.write(out);

@Repository
public interface PeopleDao extends JpaRepository<People,Serializable> {
}

@Data
@Entity
public class People implements Serializable{

    @Id@GeneratedValue
    @Excel(name = "学生Id")
    private Integer id ;
    @Excel(name = "姓名")
    private String name ;
    @Excel(name = "学生地址")
    private String site ;
    @Excel(name = "保存日期")
    private String date ;
}

@Test
    public void test2() throws IOException {

        List<People> list = peopleDao.findAll() ;
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("物联一班","测试"),People.class, list) ;
        String fileName = "D:\\test.xls";
        FileOutputStream out = new FileOutputStream(fileName) ;
        workbook.write(out);
        out.close();
        System.out.println("写入成功");
    }

@Test
    public void read1(){
        String fileName = "D:\\test.xls";
        ImportParams params = new ImportParams();
        params.setTitleRows(1);
        params.setHeadRows(1);
        long start = new Date().getTime();
        List<People> list = ExcelImportUtil.importExcel(
                new File(fileName),
                People.class, params);

        System.out.println("-----------------------------\n所耗时间：");
        System.out.println(new Date().getTime() - start);
        list.forEach(s-> System.out.println(s));
    }