1、引入easyexcel的包
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>1.0.1</version>
</dependency>
2、
List<List<String>> list = new ArrayList<>();
try {
String filePath = "example.xlsx";
OutputStream out = new FileOutputStream(filePath);
ExcelWriter writer = new ExcelWriter(out,ExcelTypeEnum.XLSX,false);
Sheet sheet1 = new Sheet(1, 0);
sheet1.setSheetName("sheet1");
writer.write0(list, sheet1);
writer.finish();
// 删除文件
File file=new File(filePath);
if(file.exists()&&file.isFile()){
file.delete();
}
return excelPath;
} catch (Exception e) {
throw new Exception("生成excel失败");
}
3、easyexcel报错显示nomethod,一定的可能是与poi包依赖冲突,删除poi依赖解决问题。