EasyPOI根据模板导出多Sheet页Excel java

复制代码
 @GetMapping(value = "downloadtest")
    public void downloadtest(HttpServletRequest request, HttpServletResponse response) throws IOException {
        List<Map<String, Object>> reportMoneyExportList = new ArrayList<>();
        Map<String, Object> moneyExport = new HashMap<>();
        moneyExport.put("seq", "1");
        moneyExport.put("projectId", "2");
        moneyExport.put("name", 3);

        Map<String, Object> moneyExport1 = new HashMap<>();
        moneyExport1.put("seq", "112122");
        moneyExport1.put("projectId", "22122");
        moneyExport1.put("name", 333);
        reportMoneyExportList.add(moneyExport);
        reportMoneyExportList.add(moneyExport1);
       
        TemplateExportParams params = new TemplateExportParams("D:\\drgTest.xls", true);
        params.setStyle(ExcelStyleType.BORDER.getClazz());
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("dataList", reportMoneyExportList);
        map.put("dataList2", reportMoneyExportList);
        Workbook book = ExcelExportUtil.exportExcel(params, map);
        File savefile = new File("D:/excel/");
        if (!savefile.exists()) {
            savefile.mkdirs();
        }
        FileOutputStream fos = new FileOutputStream("D:/excel/test.xls");
        book.write(fos);
        fos.close();
    }
复制代码

Sheet1

 

 

 Sheet2

 

posted @   .NET_海  阅读(1038)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· Manus的开源复刻OpenManus初探
· 三行代码完成国际化适配,妙~啊~
· .NET Core 中如何实现缓存的预热?
· 如何调用 DeepSeek 的自然语言处理 API 接口并集成到在线客服系统
点击右上角即可分享
微信分享提示