使用easyexcel从浏览器下载excel

添加依赖：得多加 两个依赖不然会报错误（亲身经历）
如果只加easyexcel依赖会报错误，解决：解决org.objectweb.asm.Type
如果继续报错class net.sf.cglib.core.DebuggingClassWriter has interface，解决办法：解决class net.sf.cglib.core.DebuggingClassWriter has interface

	<dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>2.2.10</version><exclusions><exclusion><groupId>cglib</groupId><artifactId>cglib</artifactId></exclusion></exclusions></dependency><dependency><groupId>asm</groupId><artifactId>asm</artifactId><version>3.3.1</version></dependency><dependency><groupId>cglib</groupId><artifactId>cglib</artifactId><version>2.2</version></dependency>

下载的代码：

@GetMapping("/testDownLoad")public void testRespExcel(HttpServletResponse response){String fileName = new String("导出excel.xlsx".getBytes(), StandardCharsets.ISO_8859_1);response.setContentType("application/vnd.ms-excel");response.setCharacterEncoding("utf8");response.setHeader("Content-disposition", "attachment;filename=" + fileName );try {
//            从HttpServletResponse中获取OutputStream输出流ServletOutputStream outputStream = response.getOutputStream();/** EasyExcel 有多个不同的read方法，适用于多种需求* 这里调用EasyExcel中通过OutputStream流方式输出Excel的write方法* 它会返回一个ExcelWriterBuilder类型的返回值* ExcelWriterBuilde中有一个doWrite方法，会输出数据到设置的Sheet中*/EasyExcel.write(outputStream, OcrFileInfoDownLoad.class).sheet("Sheet1").doWrite(employeeService.queryDownLoad());} catch (IOException e) {e.printStackTrace();}}

EmployeeService 查询的代码：

    public List<OcrFileInfoDownLoad> queryDownLoad() {return ocrFileInfoMapper.queryDownTest();}

OcrFileInfoDownLoad类：

@Data
@Builder
public class OcrFileInfoDownLoad {@ExcelProperty(value = "一级",index = 0)private String itemFirstCateName;@ExcelProperty(value = "二级",index = 1)private String itemSecondCateName;@ExcelProperty(value = "三级",index = 2)private String itemThirdCateName;}

下载下来的图片：