[移动开发] 完整easyPoi 自定义模板导出（多sheet）包含前后步骤

开发: C++知识库 Java知识库 JavaScript Python PHP知识库人工智能区块链大数据移动开发嵌入式开发工具数据结构与算法开发测试游戏开发网络协议系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑笔记本显卡显示器固态硬盘硬盘耳机手机 iphone vivo oppo 小米华为单反装机图拉丁

-> 移动开发 -> 完整easyPoi 自定义模板导出（多sheet）包含前后步骤 -> 正文阅读

[移动开发]完整easyPoi 自定义模板导出（多sheet）包含前后步骤

引入依赖：

         <dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-base</artifactId>
                <version>3.2.0</version>
        </dependency>
        <dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-web</artifactId>
                <version>3.2.0</version>
        </dependency>
        <dependency>
               <groupId>cn.afterturn</groupId>
               <artifactId>easypoi-annotation</artifactId>
               <version>3.2.0</version>
        </dependency>

一：导出方法

/*********导出部分*********/
    public static void exportExcel(String realPath, Map<String, Object> map, String fileName, HttpServletResponse response) throws IOException {
        //sheet封装
        Map<String, Object> sheetMap = new HashMap<String, Object>();
        sheetMap.put("list", map.get("list"));
        sheetMap.put("projects", map.get("projects"));

        TemplateExportParams params = new TemplateExportParams(realPath,true);
        // 设置sheetName，若不设置该参数，则使用得原本得sheet名称
//        String[] sheetNameArray = {"执法分析","整体趋势"} ;
//        params.setSheetName(sheetNameArray);
        Workbook workbook = ExcelExportUtil.exportExcel(params, map);
        downLoadExcel(fileName, response, workbook);
    }

    private static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook)  {
        try {
            response.reset();
            response.setContentType("application/x-msdownload");
            response.setHeader("Content-disposition", "attachment; filename=" + java.net.URLEncoder.encode(fileName+".xlsx", "UTF-8"));
            ServletOutputStream outStream = null;
            try {
                outStream = response.getOutputStream();
                workbook.write(outStream);
            } finally {
                outStream.close();
            }
        } catch (IOException e) {
            throw new BadRequestException( e.getMessage());
        }
    }

二：接口

  @GetMapping("/exportExcel")
    public void exportExcel(HttpServletResponse response) {
        try {
//            TemplateExportParams templatePath = new TemplateExportParams("D:/WorkSpace/模板.xls");
            Map<String, Object> map = new HashMap<>();
            map.put("index", "序号");
            map.put("year", "年度");
            List<one> list = dataOneService.list();
            List<Project> projects = ProjectService.list();
            map.put("list", list);
            map.put("projects", projects);

            //sheet封装
            ExcelUtils.exportExcel("D:/WorkSpace/模板.xls", map, "新导出文件.xlsx", response);
        } catch (Exception ex) {
            throw  new BadRequestException(ex.getMessage());
        }
    }

时间格式：

? $[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-QiqLarOV-1594782993823)(C:\Users\AirOrangeWorkSpace\Desktop\修改后.PNG)]$

前端：

js:

/**
 * 导出excel
 * @returns data
 */
export function expExcel() {
  return request({
    url: '/api/one/exportExcel',
    method: 'get',
    responseType: 'blob'
  })
}

method：

 expExcel(){
      expExcel().then((res) =>{

      const downUrl = window.URL.createObjectURL(new Blob([res]));
      const a = window.document.createElement('a');
      a.href = downUrl;
      a.download = `文件.xlsx`;
      a.click();
      window.URL.revokeObjectURL(downUrl);


      })
    }