如何更改评论字体颜色

Microsoft Excel允许用户向单元格添加评论以补充信息并突出显示数据。开发人员可能需要自定义评论以指定对齐设置、文本方向、字体颜色等。Aspose.Cells提供了API以完成此任务。

Aspose.Cells提供了一个Shape.TextBody属性以设置评论的字体颜色。以下示例代码演示了使用Shape.TextBody属性来设置评论的文本方向。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
String dataDir = "";
// Instantiate a new Workbook
Workbook workbook = new Workbook();
// Get the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

//Add some text in cell A1
worksheet.getCells().get("A1").putValue("Here");

// Add a comment to A1 cell
Comment comment = worksheet.getComments().get(worksheet.getComments().add("A1"));
// Set its vertical alignment setting
comment.getCommentShape().setTextVerticalAlignment(TextAlignmentType.CENTER);
// Set the Comment note
comment.setNote("This is my Comment Text. This is test");

Shape shape = worksheet.getComments().get("A1").getCommentShape();

shape.getFill().getSolidFill().setColor(Color.getBlack());
Font font = shape.getFont();
font.setColor(Color.getWhite());
StyleFlag styleFlag = new StyleFlag();
styleFlag.setFontColor(true);
shape.getTextBody().format(0, shape.getText().length(), font, styleFlag);

// Save the Excel file
workbook.save(dataDir + "outputChangeCommentFontColor.xlsx");

上述代码生成的输出文件作为参考附件。