1.本次使用?Easypoi? 進行導入導出 方便快捷

1.1 介紹 - Powered by MinDoc? ?這是?Easypoi? 的官方api 文檔

2.導入Maven 依賴

        <!--   excel 依賴-->
        <!--excle 導出導出-->
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>4.1.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>4.1.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>4.1.0</version>
        </dependency>

3.最重要的一步? ?resources文件夾下 創建文件目錄 template 導入 自定義的excel 文件

3.自定義模板語法

4.自定義excel 模板?

    @Override
    public void export(int id, HttpServletRequest request, HttpServletResponse response) {


        LambdaUpdateWrapper<GoodsOrder> lambdaUpdateWrapper = new LambdaUpdateWrapper<>();
        lambdaUpdateWrapper.eq(GoodsOrder::getId, id);
        GoodsOrder order = orderMapper.selectOne(lambdaUpdateWrapper);
        LambdaUpdateWrapper<OrderDetails> O_lambdaUpdateWrapper = new LambdaUpdateWrapper<>();
        O_lambdaUpdateWrapper.eq(OrderDetails::getOrderId, order.getId());
        List<OrderDetails> orderDetails = orderDetailsMapper.selectList(O_lambdaUpdateWrapper);
        HashMap<String, Object> map = new HashMap();
        if (orderDetails.size() > 0) {
            map.put("company", order.getCompany());
            map.put("order_time", order.getOrderTime());
            map.put("tel", orderDetails.get(0).getCompanyTel());
            map.put("nums", order.getNum());
            map.put("amount", order.getAmount());
            map.put("carrier", orderDetails.get(0).getCarrier());
            map.put("delivertel", orderDetails.get(0).getDeliverTel());
            map.put("receiving", orderDetails.get(0).getReceiving());
            //用于循環
            map.put("goodsList", orderDetails);
        }
        try {

            Workbook workbook = WorkbookFactory.create(getClass().getClassLoader().getResourceAsStream("template/zhien.xls"));
            TemplateExportParams params = new TemplateExportParams();
            params.setTemplateWb(workbook);
            params.setScanAllsheet(true);
            ExcelExportUtil.exportExcel(params, map);
            OutputStream outputStream = response.getOutputStream();
//            workbook.setSheetName(0, "sheet");
//            CellStyle cellStyle = workbook.createCellStyle();
//            cellStyle.setBorderRight(BorderStyle.THIN);
            //設置編碼格式
            response.setCharacterEncoding(StandardCharsets.UTF_8.name());
            //設置內容類型
            response.setContentType("application/octet-stream");
            //設置頭及文件命名。
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("銷售單.xls", StandardCharsets.UTF_8.name()));
            workbook.write(outputStream);

        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

5.前端Vue 進行導出

1.vue 前端 點擊導出事情

const download = (id: any) => {
  get_data_download(id).then((res: any) => {
    if (res.size == 76) {
      ElMessage.error("查詢的時間段 沒有數據");
    } else {
      ElMessage.success("下載完成，正在打開");
      // console.log(res);
      const blob = new Blob([res]);
      const element = document.createElement("a");
      // 配置文件名，默認是 txt，可以自定義，比如：操作日志.csv
      element.download = "銷售單" + ".xls";
      element.style.display = "none";
      element.href = URL.createObjectURL(blob);
      document.body.append(element);
      element.click();
      URL.revokeObjectURL(element.href);
      document.body.removeChild(element);
    }
  });
};

2.如果路由有 請求和響應攔截器 記得放行

/ 添加請求攔截器
service.interceptors.request.use(
    (config) => {
        // 在發送請求之前做些什么 token
        const sign = Session.get('sign');
        config.headers['sign'] = sign
        if (config.url === '/order/export'|| config.url === '/orderDetails/get_data_download') {
            config.responseType = 'blob'
        }
        let data = config.data || (config['data'] = []);
        config.data = qs.stringify(data)
        return config;


    },
    (error) => {
        // 對請求錯誤做些什么
        return Promise.reject(error);
    }
);

// 添加響應攔截器
let isReFreshPadding = true;
service.interceptors.response.use(
    (response) => {
        // 對響應數據做點什么
        const res = response.data;
        if (response.config.url === '/order/export'|| response.config.url === '/orderDetails/get_data_download') {
            return res
        }
        if (isReFreshPadding) {
            if (response.data.code == -9999 || response.data.code == -9998) {
                isReFreshPadding = false;
                ElMessage.error(res["message"])
                Session.remove("token")
                router.push({
                    path: "/login"
                })
                localStorage.clear()
                window.location.reload();
            }
        }
        if (res.code == -1) {
            isReFreshPadding = true;
            ElMessage.error(res["msg"])
            return res
        }
        if (res.code == 0) {
            isReFreshPadding = true;
            return res
        }

    },
    (error) => {
        // 對響應錯誤做點什么
        if (error.message.indexOf('timeout') != -1) {
            ElMessage.error('網絡超時');
        } else if (error.message == 'Network Error') {
            ElMessage.error('網絡連接錯誤');
        }
        return Promise.reject(error);
    }
);