maven依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>1.1.2-beta5</version>
</dependency>
java代码
import java.io.File;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.List;
import com.alibaba.excel.EasyExcelFactory;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.metadata.Sheet;
import com.alibaba.excel.metadata.Table;
public class EasyExcelUtil {
public static void main(String[] args) {
// 文件输出位置
String filePath = "E:\\360Downloads\\test.xlsx";
String sheetName = "第一个Sheet";
// 动态添加 表头 headList --> 所有表头行集合
List<List<String>> headList = new ArrayList<List<String>>();
// 第 n 行 的表头
List<String> headTitle0 = new ArrayList<String>();
List<String> headTitle1 = new ArrayList<String>();
List<String> headTitle2 = new ArrayList<String>();
List<String> headTitle3 = new ArrayList<String>();
List<String> headTitle4 = new ArrayList<String>();
headTitle0.add("姓名");
headTitle0.add("姓名");
headTitle1.add("爱好");
headTitle1.add("篮球");
headTitle2.add("爱好");
headTitle2.add("足球");
headTitle3.add("手机号");
headTitle3.add("手机号");
headTitle4.add("QQ");
headTitle4.add("QQ");
headList.add(headTitle0);
headList.add(headTitle1);
headList.add(headTitle2);
headList.add(headTitle3);
headList.add(headTitle4);
// 所有行的集合
List<List<Object>> list = new ArrayList<List<Object>>();
for (int i = 1; i <= 10; i++) {
// 第 n 行的数据
List<Object> row = new ArrayList<Object>();
row.add("第" + i + "单元格");
row.add("第" + i + "单元格");
row.add("第" + i + "单元格");
row.add("第" + i + "单元格");
row.add("第" + i + "单元格");
list.add(row);
}
}
public static void writeExcel(String sheetName, String filePath, List<List<String>> headList, List<List<Object>> nrList) {
try {
File parentFile = new File(filePath).getParentFile();
if (!parentFile.exists()) {
parentFile.mkdirs();
}
ExcelWriter excelWriter = EasyExcelFactory.getWriter(new FileOutputStream(filePath));
// 表单
Sheet sheet = new Sheet(1,0);
sheet.setSheetName(sheetName);
// 创建一个表格
Table table = new Table(1);
table.setHead(headList);
excelWriter.write1(nrList,sheet,table);
// 记得 释放资源
excelWriter.finish();
} catch (Exception e) {
e.printStackTrace();
}
}
}