easyexcel

easyExcel is one of Alibaba's open source poi plug-ins. The latest version is 1.1.2-beta5 and poi version 3.17. Therefore, when integrating old versions of poi, you need to upgrade the poi version or perform version isolation.

Mainly solves the problem of complex use of POI framework, sax parsing mode is not easy to operate, large amount of data is prone to OOM, and solves the problem of errors caused by POI concurrency (recommended learning ：PHP video tutorial)

Main solution: load by decompressing the file, load it line by line, and discard unimportant data such as style fonts and other unimportant data to reduce memory usage

EasyExcel Advantages

Annotation-based custom operations.

Simple input and output, providing an interface for the input and output process

Supports a certain degree of flexible operations such as cell merging

EasyExcel Disadvantages

The framework is immature. After version 1.1.0, only the beta version provides flexible interfaces

There are still some bugs

There is no complete set of api

ExcelUtil is fast Use

maven to reference (if there is a lower version of POI in version control, please upgrade the version and code, the official POI version is 3.17):

<dependency>
     <groupId>com.alibaba</groupId>
     <artifactId>easyexcel</artifactId>
     <version>1.1.2-beta5</version>
</dependency>

The entity class inherits BaseRowModel, and fields that need to be exported or imported Add the @ExcelProperty annotation, the index value is the corresponding column in excel, the value is the header, and the format is the date formatting

public class PersonDto extends BaseRowModel{    /** id */
    @ExcelProperty(index = 0 , value = "id")    private String id;    /** 姓名 **/
    @ExcelProperty(index = 1 , value = "姓名")    private String name;    /** 生日 **/
    @ExcelProperty(index = 2 , value = "生日" , format = "yyyy-MM-dd")    
    private String birth;
}

For more PHP related technical articles, please visitPHP graphic tutorial Column for learning!

The above is the detailed content of easyexcel. For more information, please follow other related articles on the PHP Chinese website!