EasyExcel 实现多个Sheet页导出

1 Maven依赖

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.6</version>
        </dependency>

2 实现代码

    /**
     * 导出多个sheet页数据
     *
     * @param response
     */
    @GetMapping("/exportMultiSheet")
    public void exportMultiSheet(HttpServletResponse response) {
        try {
            //第一个Sheet页数据
            List<List<Object>> dataList = new ArrayList<>();
            List<Object> headList = new ArrayList<>(Arrays.asList(new Object[]{"表头1", "表头2", "表头3"}));
            dataList.add(headList);

            //第二个Sheet页数据
            List<List<Object>> dataList2 = new ArrayList<>();
            List<Object> headList2 = new ArrayList<>