如何通过 Node.js 以及 C++ 改变评论字体颜色

Microsoft Excel 允许用户为单元格添加评论，以提供额外信息和突出显示数据。开发者可能需要自定义评论，以指定对齐设置、文本方向、字体颜色等。Aspose.Cells for Node.js via C++ 提供实现此任务的API。

Aspose.Cells for Node.js via C++ 提供一个 Shape.getTextBody() 属性，用于设置评论的字体颜色。以下示例代码演示了如何使用 Shape.getTextBody() 属性来设置评论的文本方向。

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Output directory
const outputDir = path.join(__dirname, "output");

// Instantiate a new Workbook
const workbook = new AsposeCells.Workbook();

// Get the first worksheet
const worksheet = workbook.getWorksheets().get(0);

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

// Add a comment to A1 cell
const commentIndex = worksheet.getComments().add("A1");
const comment = worksheet.getComments().get(commentIndex);

// Set its vertical alignment setting            
comment.getCommentShape().setTextVerticalAlignment(AsposeCells.TextAlignmentType.Center);

// Set the Comment note
comment.setNote("This is my Comment Text. This is Test.");

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

shape.getFill().getSolidFill().setColor(AsposeCells.Color.Black);
const font = shape.getFont();
font.setColor(AsposeCells.Color.White);
const styleFlag = new AsposeCells.StyleFlag();
styleFlag.setFontColor(true);
shape.getTextBody().format(0, shape.getText().length, font, styleFlag);

// Save the Excel file
workbook.save(path.join(outputDir, "outputChangeCommentFontColor.xlsx"));

上述代码生成的输出文件附在此供您参考。