alibaba / easyexcel

快速、简洁、解决大文件内存溢出的java处理Excel工具
https://easyexcel.opensource.alibaba.com
Apache License 2.0
32.05k stars 7.5k forks source link

导出成excel文件无法求和 #1222

Closed HusenHuang closed 3 years ago

HusenHuang commented 4 years ago

建议先去看文档 快速开始常见问题 异常代码

WriteSheet sheet = EasyExcel.writerSheet(templateModel.getSheetName())
                        .head(header)
                        .build();
                ExcelWriter excelWriter = EasyExcel.write(writePath)
                        .registerWriteHandler(EasyExcelStyleUtil.getHorizontalCellStyleStrategy())
                        .build();
                if (!CollectionUtils.isEmpty(taskSource.getAliOssInMsg())) {
                    for (AliOssInMsg inMsg : taskSource.getAliOssInMsg()) {
                        List<Map> dataMaps = queryHelper.queryToOss(inMsg.getKey(), Map.class);
                        List<List<Object>> writeList = new ArrayList<>();
                        for (Map data : dataMaps) {
                            List<Object> values = new ArrayList<>();
                            for (Map.Entry<String, String> entry : task.getTaskFieldMap().entrySet()) {
                                values.add(data.get(entry.getKey()));
                            }
                            writeList.add(values);
                        }
                        dataCount += writeList.size();
                        excelWriter.write(writeList, sheet);
                    }
                } else {
                    excelWriter.write(new ArrayList(), sheet);
                }
                excelWriter.finish();

异常提示 数值导出成excel文件无法求和 建议描述 image image

HusenHuang commented 4 years ago

image

zhuangjiaju commented 4 years ago

考虑下 支持导出支持指定类型。

xutingyin commented 4 years ago

现在是否支持列求和?

zhuangjiaju commented 3 years ago

已经在3.0.0-beta1 版本修复,beta版本会在一个月内升级成正式版。