hutool工具导出excel代码示例

一、hutool工具导出excel代码示例 1.1、pom.xml依赖包

 

      org.apache.poi
      poi
      5.1.0
  

1.2、controller层代码(以查询user表数据为列导出excel)

• controller层代码

  package com.xz.thread.controller;
  
  import com.xz.thread.service.UserService;
  import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.web.bind.annotation.RequestMapping;
  import org.springframework.web.bind.annotation.RestController;
  import javax.servlet.http.HttpServletResponse;
  /**
   * @description:
   * @author: xz
   * @create: 2022-08-23
   */
  @RestController
  @RequestMapping("/user")
  public class UserController {
  
      @Autowired
      private UserService userService;
  
      /**
       * 导出excel
       * */
      @RequestMapping("/exportExcel")
      public void exportExcel(HttpServletResponse response, String fileName){
          userService.exportExcel(response,fileName);
      }
  }
  

1.3、service层代码(以查询user表数据为列导出excel)

• service层代码

  package com.xz.thread.service;
  
  import javax.servlet.http.HttpServletResponse;
  /**
   * @description:
   * @author: xz
   * @create: 2022-08-23
   */
  public interface UserService {
      /**
       * 导出excel
       * */
      void exportExcel(HttpServletResponse response, String fileName);
  }
  

1.4、service实现层代码(以查询user表数据为列导出excel)

• service实现层代码

  package com.xz.thread.service.impl;
  
  import com.xz.thread.domain.UserEntity;
  import com.xz.thread.service.UserService;
  import com.xz.thread.util.excel.HuToolExcelUtil;
  import org.springframework.stereotype.Service;
  import javax.servlet.http.HttpServletResponse;
  import java.util.*;
  /**
   * @description:
   * @author: xz
   * @create: 2022-08-23
   */
  @Service
  public class UserServiceImpl implements UserService {
      @Override
      public void exportExcel(HttpServletResponse response, String fileName) {
          //模拟从数据库查询user数据，返回 List
          List dataList =new ArrayList();
          for(int i=0;i