Talk about POI and easyExcel

In development, we often need to excel To deal with , For example, export Excel form ,Excel The data in the table is written to the database ！
operation Excel What's more popular at present is POI and easyExcel ！

Project source code ：https://github.com/yan418/poi
Bloggers focus on ：http://goodysr.cn

POI

Construction works

 Need to guide package ：
<!-- poi  The batch operation  -Excel -->
<!-- xls(03)-->
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi</artifactId>
   <version>3.9</version>
</dependency>
<!--xlsx(07)-->
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi-ooxml</artifactId>
   <version>3.9</version>
</dependency>

POI project , The specific operation depends on the project source code , The source code is on it .
Address :https://github.com/yan418/poi

EasyExcel

EasyExcel Official website address ：https://github.com/alibaba/easyexcel

 Need to guide package ：
<!-- alibaba  Of  EasyExcel - Excel -->
   <dependency>
       <groupId>com.alibaba</groupId>
       <artifactId>easyexcel</artifactId>
       <version>2.1.7</version>
   </dependency>
   <dependency>
       <groupId>com.alibaba</groupId>
       <artifactId>fastjson</artifactId>
       <version>1.2.62</version>
</dependency>

EasyExcel The operation of

You need to add corresponding comments to the entity class @ExcelProperty(“ String title ”)

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User implements Serializable {
    

    @ExcelProperty("ID value ")
    private Integer id;
    // user name 
    @ExcelProperty(" user name ")
	private String username;
    // Real name 
    @ExcelProperty(" Real name ")
    private String realName;
    ...
}

EasyExcel Import Excel

// EasyExcel  Import  Excel
// 1.  Entity class   Add to each field @ annotation  @ExcelProperty
@Test
void testWrite() throws Exception{
    

    // List  Entity class data 
    List<User> user = userDao.getUser();
    
    //  How to write it 1   write in  Excel
    String fileName = path + "EasyExcel.xlsx";
    //  here   You need to specify which class To write , Then write the first one sheet, The name is template   Then the file stream will close automatically 
    //  If you want to use 03  be   Pass in excelType Parameters can be 
    EasyExcel.write(fileName, User.class).sheet(" title 1").doWrite(user);
    
}

EasyExcel write in Excel

@Test
 void testRead() throws Exception{
    
     String fileName = path + "EasyExcel.xlsx";
     //  here   You need to specify which to read class To read , Then read the first sheet  The file stream closes automatically 
     EasyExcel.read(fileName, DemoData.class, new DemoDataListener()).sheet().doRead();
 }

Realization function , operation Excel, The source code in Git On .