Java 导出 Excel 如何添加批注？-灵析社区
销售经理537Java 导出 Excel 如何添加批注 想在一个excel文件中通过java代码添加批注（注意不是注释），有没有推荐的方案。需求是导出时批注不能丢失，要能与Excel兼容。
一本正经写代码你直接用这些关键字直接在百度里查 " Java Excel 添加注释和批注"
Java
Workbook wb = new Workbook();
IWorksheet worksheet = wb.getActiveSheet();
IComment commentC3 = worksheet.getRange("C3").addComment("C3的注释");
IComment commentC4 = worksheet.getRange("C4").addComment("C4的注释");
IComment commentC5 = worksheet.getRange("C5").addComment("C5的注释");
wb.save("output/memo.xlsx");
"image.png" (https://wmlx-new-image.oss-cn-shanghai.aliyuncs.com/images/20241104/f92a260e4ec00f0e8243e9ec459a40d6.png)
添加批注
Java
Workbook wb = new Workbook();
IWorksheet sheet = wb.getActiveSheet();
ICommentThreaded ct = sheet.getRange("C3").addCommentThreaded("批注1","韩梅梅");
ct.addReply("回复1", "李雷");
wb.save("output/comment.xlsx");
"image.png" (https://wmlx-new-image.oss-cn-shanghai.aliyuncs.com/images/20241104/11fa1a682c47ce3a100fa84344ad1995.png)