We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
快速开始 、常见问题
返回的list不是最后一行,导出的Excel格式错乱了
ExcelWriter excelWriter = EasyExcel.write(os) .withTemplate(inputStream) .excelType(ExcelTypeEnum.XLSX) //.registerWriteHandler(mergePrevCol) .autoCloseStream(Boolean.FALSE) .build();
FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build(); List<Map<String, Object>> ttReason = reasonService.listMaps(tr); if (CollectionUtils.isNotEmpty(ttReason)) { ttReason.forEach(var -> { String category = DictUtils.getDictLabel("QPMS_STATIONARY_FISH_BONE", String.valueOf(var.get("reason_category"))); var.replace("reason_category", category);
String type = DictUtils.getDictLabel("QPMS_STATIONARY_FIVE_WHY", String.valueOf(var.get("reason_type"))); var.replace("reason_type", type); }); }
excelWriter.fill(new FillWrapper("tr", ttReason), fillConfig, writeSheet);
# 提示的异常或者没有达到的效果 <img width="846" alt="微信图片_20240418142508" src="https://github.com/alibaba/easyexcel/assets/101182381/b9ce2fa4-5583-4bf3-9506-c14a6e1222a7"> <img width="911" alt="微信图片_20240418142515" src="https://github.com/alibaba/easyexcel/assets/101182381/59444845-dfb5-4f69-8959-377f2135e997">
The text was updated successfully, but these errors were encountered:
zhuangjiaju
No branches or pull requests
建议先去看文档
快速开始 、常见问题
触发场景描述
返回的list不是最后一行,导出的Excel格式错乱了
触发Bug的代码
FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
List<Map<String, Object>> ttReason = reasonService.listMaps(tr);
if (CollectionUtils.isNotEmpty(ttReason)) {
ttReason.forEach(var -> {
String category = DictUtils.getDictLabel("QPMS_STATIONARY_FISH_BONE", String.valueOf(var.get("reason_category")));
var.replace("reason_category", category);
excelWriter.fill(new FillWrapper("tr", ttReason), fillConfig, writeSheet);
The text was updated successfully, but these errors were encountered: