使用springboot+angular导出excel

原创已于 2022-07-26 17:51:44 修改 · 502 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#angular.js #java #前端

于 2021-01-20 16:01:08 首次发布

springboot系列同时被 2 个专栏收录

34 篇文章

订阅专栏

前端

9 篇文章

订阅专栏

该博客介绍了一种前端通过HTML按钮触发，调用 TypeScript 函数，结合后端Java服务实现Excel导出的方法。前端利用data-toggle和data-target属性绑定导出功能，后端接收到请求后处理数据并创建Excel表格，最后将文件写入HTTP响应以供下载。

前端html

  <!--          导出excel-->
              <div class="col-sm-1" >
                <button   style="" type="button" class="btn btn-warning q7" data-toggle="modal" data-target="" (click)="exportExcel()">
                  {{lang['universal.exportExcel']}}
                </button>
              </div>

前端ts


  exportExcel() {
    //使用window.location.href链接跳转
    window.location.href = url() + '/dhTask/myExportExcel?time='+this.time+'&searchMsg='+this.searchMsg;
  }

后端代码

 //PC端导出excel
    @RequestMapping("/myExportExcel")
    public void pcExportExcel(HttpServletRequest request, HttpServletResponse response, String time, String searchMsg) {
         time = request.getParameter("time");
         searchMsg = request.getParameter("searchMsg");

            //获取查询后的任务list
            List<Map<String, Object>> list = dhTaskService.pcGetBatchTaskMsg(searchMsg, time);
            List<Map<String, Object>> allList = new ArrayList<>();
            //遍历任务list获取其详细的信息，并将其加到allList中
            for (Map<String, Object> map : list) {
                Object production_task_id = map.get("production_task_id");
                List<Map<String, Object>> partList = dhTaskService.getMsgByBatchTaskId(Long.parseLong(production_task_id.toString()));
                allList.addAll(partList);
            }

            //文档
            HSSFWorkbook wb = new HSSFWorkbook();
            //表名
            HSSFSheet sheet = wb.createSheet("批次任务");
            //第一行
            HSSFRow row0 = sheet.createRow(0);
            row0.createCell(0).setCellValue("任务名称");
            row0.createCell(1).setCellValue("产品名称");
            row0.createCell(2).setCellValue("供应商名称");
            row0.createCell(3).setCellValue("等级");
            row0.createCell(4).setCellValue("等级名称");
            row0.createCell(5).setCellValue("下限");
            row0.createCell(6).setCellValue("上限");
            row0.createCell(7).setCellValue("数量");
            row0.createCell(8).setCellValue("重量");
            row0.createCell(9).setCellValue("开始时间");
            row0.createCell(10).setCellValue("结束时间");


            String end_time="";


            for (int i = 0; i < allList.size(); i++) {
                HSSFRow tempRow = sheet.createRow(i + 1);
                if(allList.get(i).get("production_task_name")!=null){
                    tempRow.createCell(0).setCellValue(allList.get(i).get("production_task_name").toString());
                }else{
                    tempRow.createCell(0).setCellValue("");
                }

                tempRow.createCell(1).setCellValue(allList.get(i).get("product_name").toString());
                tempRow.createCell(2).setCellValue(allList.get(i).get("company_name").toString());
                tempRow.createCell(3).setCellValue(allList.get(i).get("rank_num").toString());
                tempRow.createCell(4).setCellValue(allList.get(i).get("rank_name").toString());
                tempRow.createCell(5).setCellValue(allList.get(i).get("lower_limit").toString());
                tempRow.createCell(6).setCellValue(allList.get(i).get("upper_limit").toString());
                tempRow.createCell(7).setCellValue(allList.get(i).get("number").toString());
                tempRow.createCell(8).setCellValue(allList.get(i).get("weight").toString());
                tempRow.createCell(9).setCellValue(allList.get(i).get("start_time").toString());
                if(allList.get(i).get("end_time")!=null){
                    tempRow.createCell(10).setCellValue(allList.get(i).get("end_time").toString());
                }else{
                    tempRow.createCell(10).setCellValue("");
                }

            }

            // 输出Excel文件

            try {
                OutputStream output = response.getOutputStream();
                response.setHeader("Content-Disposition", "attchement;filename=" + new String("批次任务".getBytes("utf-8"), "ISO-8859-1") + ".xls");
                response.setContentType("application/msexcel");
                wb.write(output);
                output.close();

            } catch (IOException e) {
            }
            finally {
                if(wb!=null){
                    try {
                        wb.close();

                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
            }



    }
    ```