自用备忘录文档,学习请转至官网或git
依赖
<!-- easy excel -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.6</version>
</dependency>
private String demo( String expFileFullPath) throws Exception{
// 准备文件
File file = new File(expFileFullPath);
// 写入文件内容
ExcelWriter excelWriter = null;
try (InputStream templateIs = new ClassPathResource(OUTPUT_FILE_PATH).getInputStream()) {
excelWriter = EasyExcel.write(file).withTemplate(templateIs).build();
// 写入各 sheet 数据
List<AlipayClassifyResultClassifyType> classifyTypes = getAllHotelDetailBillType();
for (AlipayClassifyResultClassifyType classifyType : classifyTypes) {
WriteSheet sheet = EasyExcel.writerSheet(classifyType.getDesc()).build();
boolean haveData = false;
for (int offset = 0, count = 1000; ; offset += count) {
List<StoreItemBillDetail> results = detailMapper.listByType(type,,offset,count);
if (results.size() > 0) {
haveData=true;
excelWriter.fill(results, sheet);
}
if (results.size() < count) {
break;
}
}
if(!haveData){
List<StoreItemBillDetail> results = new ArrayList<>();
excelWriter.fill(results, sheet);
}
}
} catch (Exception e) {
LOGGER.error("demo Exception",e);
throw e;
} finally {
if (excelWriter != null) {
excelWriter.finish();
}
}