简单的导出excel基于阿里

最新推荐文章于 2024-07-02 11:52:14 发布

王威振的csdn

最新推荐文章于 2024-07-02 11:52:14 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/saygood999/article/details/88971589

本文介绍如何利用阿里巴巴的EasyExcel库实现批量数据导出到Excel文件的过程。通过示例代码展示了设置Maven依赖、编写导出方法及定义自定义类的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

所需maven依赖
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>easyexcel</artifactId>
  <version>1.1.2-beta4</version>
</dependency>

程序代码
public void exportBatchExcel(HttpServletResponse response, List list, String fileName) throws IOException {//list集合为导出的数据
  ServletOutputStream out = null;
  out = response.getOutputStream();
  ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLSX, true);
  try {
    Sheet sheet = new Sheet(1, 0, QyBuildingQual.class);//QyBuildingQual自定义类
    writer.write(list, sheet);
    response.setCharacterEncoding("utf-8");
    response.setContentType("application/vnd.ms-excel");
    response.setContentType("application/vnd.ms-excel");
    response.setHeader("content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName + ".xlsx", "utf-8"));
    out.flush();
  }catch (Exception e){
    e.printStackTrace();
  }finally {
    writer.finish();
    out.close();
  }
}

QyBuildingQual类

public class QyBuildingQual extends BaseRowModel {//BaseRowModel 必须继承此类
    /**
     *办件流水号
     */
    @ExcelProperty(value = "办件流水号",index =0)
    private String orderNum;

    /**
     *企业名称
     */
    @ExcelProperty(value = "企业名称",index = 2)
    private String compName;

}