在工作中Excel的导入和导出应该算是简单的业务吧,之前有用原生的写过,使用Hutool工具类实现此功能还是第一次。官网地址:https://hutool.cn/docs/ 第一次接触的小伙伴们可以自行进行阅读,此博客只介绍在项目中的应用及自己踩到的坑,高手可以忽略,不喜勿喷!
导出Excel
public void getComExcelService(HttpServletResponse response) {
List<ZbComVo> mqSendTaskDTO = zbComMapper.selectZbProExcel();
System.err.println(mqSendTaskDTO.toString());
for(ZbComVo zcv:mqSendTaskDTO){
if(zcv != null){
ExcelWriter writer = cn.hutool.poi.excel.ExcelUtil.getWriter(true);
writer.addHeaderAlias("comName", "企业名称");
writer.addHeaderAlias("comQybm", "企业编码");
writer.addHeaderAlias("comQyxz", "企业性质");
writer.addHeaderAlias("comFrdb", "法人代表");
writer.addHeaderAlias("comStszsf", "所在省份");
writer.addHeaderAlias("comZz", "资质");
writer.addHeaderAlias("comWz", "违章");
writer.addHeaderAlias("comLxdw", "联系单位");
writer.addHeaderAlias("comZxdz", "注册地址");
writer.write(mqSendTaskDTO, true);
writer.autoSizeColumnAll();
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
response.setHeader("Content-Disposition","attachment;filename="+ UUID.randomUUID().toString().replace("-","")+ ".xlsx");
ServletOutputStream out= null;
try {
out = response.getOutputStream();
} catch (IOException e) {
e.printStac