ps
path : 生成之后的文件路径
data : 数据库拿到的数据
sheet : excel表单名
/**
所需依赖
*/
<!-- easy excel-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.1</version>
</dependency>
/**
* Description 简单导入excel工具类
* @param path 导入excel表格路径
* @param data 导入的数据
* @param sheetName 表单名
*/
public void writeExcel(String path,List<?> data,String sheetName){
if(null !=path){
//构建easy excel
ExcelWriter excelWriter = EasyExcel.write(path, cnarea_2018.class).build();
//构建sheet构造器
WriteSheet Beijing = EasyExcel.writerSheet(sheetName).build();
//写入数据
excelWriter.write(data,Beijing);
excelWriter.finish();
}
}
@Test
void t1() {
// 通过分页拿到数据
RowBounds rowBounds = new RowBounds(0,2000);
List<cnarea_2018> cnarea_2018s = areaDao.selectByRowBounds(area, rowBounds);
//保存excel的本地地址
String path="C:\\Users\\lucky\\Desktop\\"+System.currentTimeMillis()+".xls";
//调用工具类
easyExcelUtils.writeExcel(path,cnarea_2018s,"北京地区");
}