java使用EasyExcel导入导出excel

<!-- poi 相关-->
<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)    //标题高度
@columnwidth(40)
public class orderexcel {
    //设置excel表头名称
    @excelproperty(value = "编号", index = 0)
    private long id;
    @datetimeformat("yyyy年mm月dd日hh时mm分ss秒")
    @excelproperty(value = "创建时间", index = 1)
    private date createtime;
}

public void excel() {
        //欲导出excel的数据结果集
        list<orderexcel> excel = new arraylist<>();
        //省略 向结果集里插入数据的操作

        //uuid生成唯一name
        string name = uuid.randomuuid().tostring().replaceall("-", "") + ".xlsx";
        //实现excel写的操作

        //1 设置写入文件夹地址和excel文件名称
        string filename = "/路径" + name;
        jsonobject json = new jsonobject();
        try {
            // 2 调用easyexcel里面的方法实现写操作
            // write方法两个参数：第一个参数文件路径名称，第二个参数实体类class
            easyexcel.write(filename, orderexcel.class).sheet("名字").dowrite(excel);
            //上传到fastdfs上 不上传的话只有本机可以找到，在上面路径下生成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();
        }
    }