使用easyExcel进行导出

1.导入pom文件

<!-- 阿里开源EXCEL -->

          <dependency>

              <groupId>com.alibaba</groupId>

              <artifactId>easyexcel</artifactId>

              <version>1.0.2</version>

          </dependency>

 

 

 

 

2.页面请求

window.location =  "/download?bgTime="+bgTime+"&edTime="+edTime+"&clientName="+clientName;

 

 

注意这里必须加这个 否则可能出现后台运行成功 但是下载的文件出不来

 

3.编写bean 必须继承BaseRowModel   必须有set方法

package com.mms.entity;

import com.alibaba.excel.annotation.ExcelProperty;

import com.alibaba.excel.metadata.BaseRowModel;

public class User extends BaseRowModel {

     @ExcelProperty(value = "客户名称", index = 2)

     private String custom;

     

     @ExcelProperty(value = "id", index = 1)

     private