史上最全easyexcel版的Excel导入导出

private int age;

@ExcelProperty(value = “学校”,index = 2)

private String school;

}

2、调用方法

String filePath = “/home/chenmingjian/Downloads/测试.xlsx”;

ArrayList data = new ArrayList<>();

for(int i = 0; i < 4; i++){

TableHeaderExcelProperty tableHeaderExcelProperty = new TableHeaderExcelProperty();

tableHeaderExcelProperty.setName(“cmj” + i);

tableHeaderExcelProperty.setAge(22 + i);

tableHeaderExcelProperty.setSchool(“清华大学” + i);

data.add(tableHeaderExcelProperty);

}

ExcelUtil.writeWithTemplate(filePath,data);

多个Sheet导出

=========

1、定义好模型对象

package com.springboot.utils.excel.test;

import com.alibaba.excel.annotation.ExcelProperty;

import com.alibaba.excel.metadata.BaseRowModel;

import lombok.Data;

import lombok.EqualsAndHashCode;

/**

• @description:

• @author: chenmingjian

• @date: 19-4-3 14:44

*/

@EqualsAndHashCode(callSuper = true)

@Data

public class TableHeaderExcelProperty extends BaseRowModel {

/**

• value: 表头名称

• index: 列的号, 0表示第一列

*/

@ExcelProperty(value = “姓名”, index = 0)

private String name;

@ExcelProperty(value = “年龄”,index = 1)

private int age;

@ExcelProperty(value = “学校”,index = 2)

private String school;

}

2、调用方法

ArrayList<ExcelUtil.MultipleSheelPropety> list1 = new ArrayList<>();

for(int j = 1; j < 4; j++){

ArrayList list = new ArrayList<>();

for(int i = 0; i < 4; i++){

TableHeaderExcelProperty tableHeaderExcelProperty = new TableHeaderExcelProperty();

tableHeaderExcelProperty.setName(“cmj” + i);

tableHeaderExcelProperty.setAge(22 + i);

tableHeaderExcelProperty.setSchool(“清华大学” + i);

list.add(tableHeaderExcelProperty);

}

Sheet sheet = new Sheet(j, 0);

sheet.setSheetName(“sheet” + j);

ExcelUtil.MultipleSheelPropety multipleSheelPropety = new ExcelUtil.MultipleSheelPropety();

multipleSheelPropety.setData(list);

multipleSheelPropety.setSheet(sheet);

list1.add(multipleSheelPropety);

}

ExcelUtil.writeWithMultipleSheel(“/home/chenmingjian/Downloads/aaa.xlsx”,list1);

工具类

===

package com.springboot.utils.excel;

import com.alibaba.excel.EasyExcelFactory;

import com.alibaba.excel.ExcelWriter;

import com.alibaba.excel.context.AnalysisContext;

import com.alibaba.excel.event.AnalysisEventListener;

import com.alibaba.excel.metadata.BaseRowModel;

import com.alibaba.excel