<!--  poi工具類-->
    <dependency>
        <groupId>com.deepoove</groupId>
        <artifactId>poi-tl</artifactId>
        <version>1.12.0</version>
    </dependency>

 @GetMapping(value = "/all")
    @SneakyThrows
    public void table(All all, HttpServletResponse response) {

        /* 假數(shù)據(jù) */
        all.setCode("2022-12-ABC");
        all.setBuyer("步爾斯特航天有限公司");
        String[][] strings = new String[100][5];
        for (int i = 0; i < 100; i++) {
            strings[i] = new String[]{i + "", "黃金", "100", "人民幣", "125"};
        }
        all.setTableArray(strings);

        // 模版路徑
        String wordPath = "/Users/issavior/java/java/seckill-redis/test/src/main/resources/";
        String modelName = "all.docx";

        String c = "購買方(Buyer): \n" +
                "名稱(Name)：" + all.getBuyer() + "\n" +
                "地址(Address)：杭州市余杭區(qū)大東路100號\n" +
                "電話(Tel.)：021-20855588\n" +
                "\n" +
                "銷售方(Seller):\n" +
                "名稱(Name)：杭州火箭制造有限公司\n" +
                "地址(Address)：杭州市余杭區(qū)大東路919號\n" +
                "電話(Tel.)：021-20855553\n" +
                "開戶行(Bank)：中國農(nóng)業(yè)銀行杭州支行\(zhòng)n" +
                "賬號(Account No.)：033270-00873333567";

        // 手繪表格
        // 表頭
        RowRenderData row0 = Rows.of(c, "", "", "", "").textBold().create();
        RowRenderData row1 = Rows.of("序號", "名稱", "數(shù)量", "貨幣", "價格").center().create();

        int length = 0;
        if (all.getTableArray() != null) {
            length = all.getTableArray().length;
        }
        // 表格數(shù)據(jù) 加上2行表頭 再加上最后一行總價
        RowRenderData[] rowRenderData = new RowRenderData[length + 3];
        rowRenderData[0] = row0;
        rowRenderData[1] = row1;
        // 計算價錢
        BigDecimal totalPrice = new BigDecimal("0");
        for (int i = 0; i < length; i++) {
            rowRenderData[i + 2] = Rows.of(all.getTableArray()[i]).center().create();
            String s = all.getTableArray()[i][4];
            BigDecimal bigDecimal = new BigDecimal(s);
            totalPrice = totalPrice.add(bigDecimal);
        }

        RowRenderData row4 = Rows.of("總價：" + totalPrice, "", "", "小寫", totalPrice.toString()).center().create();
        rowRenderData[rowRenderData.length - 1] = row4;
        // 表格合并,根據(jù)坐標
        MergeCellRule rule = MergeCellRule.builder().map(MergeCellRule.Grid.of(0, 0), MergeCellRule.Grid.of(0, 4)).
//                map(MergeCellRule.Grid.of(0, 1), MergeCellRule.Grid.of(1, 1)).
//                map(MergeCellRule.Grid.of(0, 2), MergeCellRule.Grid.of(0, 3)).
//                map(MergeCellRule.Grid.of(0, 4), MergeCellRule.Grid.of(1, 4)).
                map(MergeCellRule.Grid.of(rowRenderData.length - 1, 0), MergeCellRule.Grid.of(rowRenderData.length - 1, 2)).
                build();

        TableRenderData table = Tables.of(rowRenderData).mergeRule(rule).create();
        // 數(shù)據(jù)封裝
        all.setTableRenderData(table);
        // 傳入模板模板地址+信息數(shù)據(jù)
        XWPFTemplate template = XWPFTemplate.compile(wordPath + modelName).render(all);
        // 指定下載的文件名--設置響應頭
        response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("發(fā)票.docx", "UTF-8"));
        response.setContentType("application/vnd.ms-excel;charset=UTF-8");
        response.setHeader("Pragma", "no-cache");
        response.setHeader("Cache-Control", "no-cache");
        response.setDateHeader("Expires", 0);
        try {
            OutputStream out = response.getOutputStream();
            BufferedOutputStream bos = new BufferedOutputStream(out);
            template.write(out);
            bos.flush();
            out.flush();
            template.close();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }