阿里开源工具-easyExcel

1.导入esayExcel工具 

<dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>1.1.1</version></dependency>

2.导出的对象加上对应的注解 

@ExcelProperty(value = "第一列",index = 0)private BigDecimal consumeHours ;@ExcelProperty(value = "第2列",index = 1)private BigDecimal consumeHoursFees ;//预排课时数@ExcelProperty(value = "第3列",index = 2)private BigDecimal scheduledHours;//预计营收@ExcelProperty(value = "第4列",index = 3)private BigDecimal estimatedRevenue;//差额收入@ExcelProperty(value = "第5列",index = 4)private BigDecimal differentialIncome ;//营收收入@ExcelProperty(value = "第6列",index = 5)private BigDecimal revenue;

 List<RevenuePerformanceForCityDto> list = (List<RevenuePerformanceForCityDto>) this.byCity(model).getData();String fileName = "报表" + DateUtils.getNow();
response.setHeader("Content-disposition", "attachment;filename=" + java.net.URLEncoder.encode(fileName, "UTF-8") + ".xlsx");EasyExcel.write(response.getOutputStream(), RevenuePerformanceForCityDto.class).sheet("报表").doWrite(list);