如何更改评论字体颜色

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

Aspose.Cells提供了形状.TextBody属性为注释的字体颜色。下面的示例代码演示了使用形状.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");

这输出文件附上上述代码生成的代码供大家参考。