阿里开源工具-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);