@Test
    public void complexFillWithTable() {
        // Template note: Use {} to represent variables. If the template contains "{", "}" as special characters, use "\{", "\}" instead.
        // {} represents a regular variable, {.} represents a list variable.
        // Here, the template removes data after the list, such as summary rows.
        String templateFileName =
            TestFileUtil.getPath() + "demo" + File.separator + "fill" + File.separator + "complexFillWithTable.xlsx";

        String fileName = TestFileUtil.getPath() + "complexFillWithTable" + System.currentTimeMillis() + ".xlsx";
        ExcelWriter excelWriter = EasyExcel.write(fileName).withTemplate(templateFileName).build();
        WriteSheet writeSheet = EasyExcel.writerSheet().build();
        // Directly write data
        excelWriter.fill(data(), writeSheet);
        excelWriter.fill(data(), writeSheet);

        // Write data before the list
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("date", "2019-10-09 13:28:28");
        excelWriter.fill(map, writeSheet);

        // Manually write summary data after the list
        // Here, we use a list for simplicity, but an object could also be used.
        List<List<String>> totalListList = new ArrayList<List<String>>();
        List<String> totalList = new ArrayList<String>();
        totalListList.add(totalList);
        totalList.add(null);
        totalList.add(null);
        totalList.add(null);
        // Fourth column
        totalList.add("Total: 1000");
        // Use `write` instead of `fill` here
        excelWriter.write(totalListList, writeSheet);
        excelWriter.finish();
        // Overall, this approach is complex, but no better solution is available.
        // Asynchronous writing to Excel does not support row deletion or movement, nor does it support comments.
        // Therefore, this workaround is necessary.
    }
Example of complex data filling with large datasets.
<p>
The solution here is to ensure the list in the template is the last row, then append a table.
Note: Excel 2003 format is not supported and requires more memory.

@since 2.1.1
fastexcel-test/src/test/java/cn/idev/excel/test/temp/fill/FillTempTest.java