Java如何使用EasyExcel實現(xiàn)導(dǎo)入導(dǎo)出excel

<!-- poi 相關(guān)-->
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi</artifactId>
	<version>3.17</version>
</dependency>
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml-schemas</artifactId>
	<version>3.17</version>
</dependency>
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.17</version>
</dependency>
<!-- esayexcel 2.1.7  -->
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>easyexcel</artifactId>
	<version>2.1.7</version>
</dependency>

@ExcelProperty(value = "編號", index = 0)
private Long id;

public class ImeiEncrypt {
    @ColumnWidth(value = 255) //excel單個單元格最大長度255
    private String message;
}

package com.pingou.admin.bean.param;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

@Data
@ContentRowHeight(35) //文本行高度
@HeadRowHeight(40)    //標(biāo)題高度
@ColumnWidth(40)
public class OrderExcel {
    //設(shè)置excel表頭名稱
    @ExcelProperty(value = "編號", index = 0)
    private Long id;
    @DateTimeFormat("yyyy年MM月dd日HH時mm分ss秒")
    @ExcelProperty(value = "創(chuàng)建時間", index = 1)
    private Date createTime;
}

public void excel() {
        //欲導(dǎo)出excel的數(shù)據(jù)結(jié)果集
        List<OrderExcel> excel = new ArrayList<>();
        //省略 向結(jié)果集里插入數(shù)據(jù)的操作

        //UUID生成唯一name
        String name = UUID.randomUUID().toString().replaceAll("-", "") + ".xlsx";
        //實現(xiàn)excel寫的操作

        //1 設(shè)置寫入文件夾地址和excel文件名稱
        String filename = "/路徑" + name;
        JSONObject json = new JSONObject();
        try {
            // 2 調(diào)用easyexcel里面的方法實現(xiàn)寫操作
            // write方法兩個參數(shù)：第一個參數(shù)文件路徑名稱，第二個參數(shù)實體類class
            EasyExcel.write(filename, OrderExcel.class).sheet("名字").doWrite(excel);
            //上傳到fastdfs上 不上傳的話只有本機(jī)可以找到，在上面路徑下生成excel  
            File file = new File(filename);
            String path = fastDFSClient.upload(new FileInputStream(file), name, null);
            path = (this.fastdfsDomain + path);
            json.put("url", path);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            new File(filename).delete();
        }
    }