easyexcel-导入

package com.meeno.framework.util.easyexcel.entity;

import cn.afterturn.easypoi.excel.annotation.Excel;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

import java.util.Date;

/**

 * @description:

 * @author: Wzq

 * @create: 2020-03-24 20:19

 */

@Data

@AllArgsConstructor

@NoArgsConstructor

public class AuthExcelModel {

    private String code;

    private String name;

    private String  categoryName;

    private String categoryChildrenName;

    private String parentCode;

    private String parentName;

    private Date createDate;

}



package com.meeno.framework.util.easyexcel.listener;

//import com.alibaba.excel.context.AnalysisContext;

//import com.alibaba.excel.event.AnalysisEventListener;

import com.meeno.framework.util.easyexcel.entity.AuthExcelModel;

import lombok.Data;

import java.util.ArrayList;

import java.util.List;

/**

 * @description: Listener

 * @author: Wzq

 * @create: 2020-03-25 10:16

 */

@Data

public class AuthExcelModelListener  extends AnalysisEventListener<AuthExcelModel> {

    List<AuthExcelModel> list = new ArrayList<AuthExcelModel>();

    @Override

    public void invoke(AuthExcelModel authExcelModel, AnalysisContext analysisContext) {

        list.add(authExcelModel);

    }

    @Override

    public void doAfterAllAnalysed(AnalysisContext analysisContext) {

    }*/

}

EasyExcel.read(file.getInputStream(), AuthExcelModel.class, authExcelModelListener).sheet().doRead();

巴特西

easyexcel-导入

最新文章

热门文章