在工作表中设置表格或列表对象的注释
Contents
[
Hide
]
请使用IListObject.评论方法。注释将在 xl/tables/tableName.xml 文件中可见。
在工作表中设置表格或列表对象的注释
以下示例代码加载源 excel 文件并设置工作表内第一个表或列表对象的注释。
This file contains hidden or 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-C | |
// Instantiate a Workbook object and open an Excel file | |
intrusive_ptr<IWorkbook> workbook =Factory::CreateIWorkbook(dataDir_Tables->StringAppend(new String("source.xlsx"))); | |
// Accessing the first worksheet in the Excel file | |
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0); | |
// Get the List objects collection in the first worksheet. | |
intrusive_ptr<IListObjectCollection> listObjects = worksheet->GetIListObjects(); | |
// Set the comment of the first list object | |
listObjects->GetObjectByIndex(0)->SetComment(new String("This is Aspose.Cells comment.")); | |
// Saving the Excel file | |
workbook->Save(dataDir_Tables->StringAppend(new String("SetCommentOfTableOrListObject_out.xlsx")), SaveFormat_Xlsx); |