spring html导出excel文件,easypoi + spring boot 导入、导出excel文件

pox.xml添加依赖

cn.afterturn

easypoi-web

3.2.0

定义一个类，在每个属性上面添加@Excel注解，并设置name值，注意name的值要与excel文件中的字段一一对应

@Data

public class WeiUser implements Serializable {

private static final long serialVersionUID = 337215436114100948L;

@Excel(name = "id")

private Integer id;

@Excel(name = "openid")

private String openid;

@Excel(name = "nickname")

private String nickname;

@Excel(name = "sex")

private Integer sex;

@Excel(name = "city")

private String city;

@Excel(name = "country")

private String country;

@Excel(name = "province")

private String province;

@Excel(name = "headimgurl")

private String headimgurl;

@Excel(name = "subscribe")

private String subscribe;

@Excel(name = "language")

private String language;

@Excel(name = "remark")

private String remark;

private Integer[] ids;

}

前端代码

Title

controller层代码

导入

//导入表格

@RequestMapping("/upload")

@ResponseBody

public String upload(@RequestParam("file") MultipartFile multipartFile) throws Exception {

ImportParams params = new ImportParams();

params.setHeadRows(1);

// 解析excel文件，得到的result是一个包含所有记录的集合

List result = ExcelImportUtil.importExcel(multipartFile.getInputStream(),

WeiUser.class, params);

//调用service层的add方法将集合中的每条数据插入到数据库

userService.addList(result);

return "success";

}

导出

//导出表格

@RequestMapping("/out")

public String exportCompanyImg(HttpServletRequest request) throws Exception {

//调用service层的方法获取数据库中数据，返回一个list集合

List list = userService.getList();

File savefile = new File("F:/excel/");

//如果指定路径没有excel目录就创建一个

if (!savefile.exists()) {

savefile.mkdirs();

}

//将list集合转换成workbook文件

Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), WeiUser.class, list);

//指定导出文件的存储路径

FileOutputStream fos = new FileOutputStream("F:/excel/ExcelExportHasImgTest.exportCompanyImg.xls");

//将文件写入指定位置

workbook.write(fos);

//关流

fos.close();

return this.getList(request,null,null);

}