springboot和vue实现导入导

最新推荐文章于 2025-01-09 17:31:17 发布

m0_62656650

最新推荐文章于 2025-01-09 17:31:17 发布

阅读量156

点赞数

文章标签： java

本文链接：https://blog.csdn.net/m0_62656650/article/details/129696415

版权

该代码段展示了一个SpringMVC控制器方法，用于导出用户信息到Excel文件。它首先从userService获取用户列表，然后利用Hutool库创建ExcelWriter，设置列别名，写入数据，并设定HTTP响应头以提供下载。依赖包括Hutool-all和ApachePOI的ooxml库。

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

    @GetMapping("/export")
    public  void export(HttpServletResponse response) throws Exception{
        List<user> list = userserviceinterimpl.lookuser();
      ExcelWriter   writer =  ExcelUtil.getWriter(true);

      writer.addHeaderAlias("id","用户id");
      writer.addHeaderAlias("label","用户标签");
      writer.addHeaderAlias("value","用户值");
      writer.addHeaderAlias("pid","价格id");

      writer.write(list,true);
      response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
        String fileName = URLEncoder.encode("用户信息", "UTF-8");
        response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx");
        ServletOutputStream out = response.getOutputStream();
        writer.flush(out, true);
        out.close();
        writer.close();
    }

pom.xml

        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.7.20</version>
        </dependency>

        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>