当前位置： 移动技术网 > IT编程>开发语言>Java > easypoi导出excel表格数据

easypoi导出excel表格数据

2020年07月03日  | 移动技术网IT编程  | 我要评论 
@ApiOperation(value = "列表数据导出")
@PostMapping(value = "/preFollowListExport", produces = "application/json;charset=UTF-8")
    public void export(HttpServletResponse servletResponse) throws IOException {
      
                String name = "数据表";
                servletResponse.setHeader("content-Type", "application/vnd.ms-excel");
                servletResponse.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(name + ".xls", "utf-8"));
                servletResponse.setHeader("Access-Control-Expose-Headers", "ContentDisposition");
                
                //获取数据源
                List<DataBean> list = null;

                ExportParams params = new ExportParams(name, "sheet1");
                Workbook workbook = ExcelExportUtil.exportBigExcel(params, DataBean.class, list);
                ExcelExportUtil.closeExportBigExcel();
                try {
                    workbook.write(servletResponse.getOutputStream());
                }catch (IOException e) {
                    e.printStackTrace();
                }finally {
                    workbook.close();
                }
           
  
    }

 

 

数据实体对象：

@Data
@ExcelTarget(value = "dataBean")
public class DataBean implements Serializable {

    @Excel(name = "序号")
    private Integer sortNum;

    @Excel(name = "姓名")
    private String name;
}

 

本文地址：https://blog.csdn.net/qq_34707456/article/details/107069917

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网