vue springboot 实现excel导出

el-button type="success" @click="handleExport">导出i class="el-icon-upload el-icon--right">i>el-button>
handleExport() {
  let a = document.createElement(‘a‘)
  a.href = "http://www.soscw.com/xxx/export"
  a.click()
}         

dependency>
  groupId>cn.afterturngroupId>
  artifactId>easypoi-spring-boot-starterartifactId>
  version>4.1.0version>
dependency>

dependency>
  groupId>commons-fileuploadgroupId>
  artifactId>commons-fileuploadartifactId>
  version>1.4version>
dependency>

@Data
public class UnitMaterialRecommendVo {
    @Excel(name = "序号", width = 10)
    private Integer num;
    @Excel(name = "体系", width = 25, orderNum = "1")
    private String unitSystem;
    @Excel(name = "单位", width = 25, orderNum = "2")
    private String unitName;
    @Excel(name = "参评类型", width = 25, orderNum = "3", replace = { "参评单位申报推荐_10", "文明单位复查审核_20" })
    private Integer reportType;
    @Excel(name = "审核结果", width = 25, orderNum = "4", replace = { "审核中_0", "审核通过_1", "审核不通过_-1" })
    private Integer state;
    @Excel(name = "联系方式", width = 25, orderNum = "5")
    private String unitDirectorPhone;
    @Excel(name = "所属省市", width = 25, orderNum = "6")
    private String unitCityName;
    @Excel(name = "文明单位类型", width = 25, orderNum = "7", replace = { "四川省文明单位_10", "四川省最佳文明单位_20"})
    private Integer civilizedUnitType;
    @Excel(name = "备注", width = 30, orderNum = "8")
    private String remark;
}

List list = this.list(wrapper);
String fileName = new String("文件名称.xls".getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1);
response.addHeader("Content-Disposition", "attachment;filename=" + fileName);
response.setContentType("application/vnd.ms-excel;charset=gb2312");
List result = new ArrayList();
AtomicInteger num = new AtomicInteger(1);
// 设置序号
list.forEach(item -> item.setNum(num.getAndIncrement()));
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), UnitMaterialRecommendVo.class, result);
workbook.write(response.getOutputStream());