如何更改评论字体颜色
Contents
[
Hide
]
Microsoft Excel允许用户向单元格添加评论以补充信息并突出显示数据。开发人员可能需要自定义评论以指定对齐设置、文本方向、字体颜色等。Aspose.Cells提供了API以完成此任务。
Aspose.Cells提供了一个Shape.TextBody属性来设置评论的字体颜色。以下示例代码演示了使用Shape.TextBody属性来设置评论的字体颜色。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//Output directory | |
string outputDir = RunExamples.Get_OutputDirectory(); | |
// Instantiate a new Workbook | |
Workbook workbook = new Workbook(); | |
// Get the first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
//Add some text in cell A1 | |
worksheet.Cells["A1"].PutValue("Here"); | |
// Add a comment to A1 cell | |
var comment = worksheet.Comments[worksheet.Comments.Add("A1")]; | |
// Set its vertical alignment setting | |
comment.CommentShape.TextVerticalAlignment = TextAlignmentType.Center; | |
// Set the Comment note | |
comment.Note = "This is my Comment Text. This is Test."; | |
Shape shape = worksheet.Comments["A1"].CommentShape; | |
shape.Fill.SolidFill.Color = Color.Black; | |
Font font = shape.Font; | |
font.Color = Color.White; | |
StyleFlag styleFlag = new StyleFlag(); | |
styleFlag.FontColor = true; | |
shape.TextBody.Format(0, shape.Text.Length, font, styleFlag); | |
// Save the Excel file | |
workbook.Save(outputDir + "outputChangeCommentFontColor.xlsx"); |
上述代码生成的输出文件附在此供您参考。