easypoi导出数值型_java开发easypoi导出excel表格数据

@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 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

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！