Add Comments in Excel Worksheets using C++

readme.md

You can find detailed information at: Add Comments in Excel Worksheets using C++

Add_Comment.cpp

// Source directory path.
StringPtr srcDir = new String("SourceDirectory\\Excel\\");

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Load the source Excel file
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook(srcDir->StringAppend(new String("Sample1.xlsx")));

// Retrieve the first worksheet
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Add comment to the cell F5
int commentIndex = worksheet->GetIComments()->Add(new String("F5"));

// Retrieve the comment added to the cell F5
intrusive_ptr<IComment> comment = worksheet->GetIComments()->GetObjectByIndex(commentIndex);

// Set the comment note
comment->SetNote(new String("Hello Aspose!"));

// Save the Excel file
workbook->Save(outDir->StringAppend(new String("AddComment_out.xlsx")));

Apply_Formatting_To_Comment.cpp

// Source directory path.
StringPtr srcDir = new String("SourceDirectory\\Excel\\");

// Output directory path.
StringPtr outDir = new String("OutputDirectory\\");

// Load the source Excel file
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook(srcDir->StringAppend(new String("Sample1.xlsx")));

// Retrieve the first worksheet
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// Add comment to the cell F5
int commentIndex = worksheet->GetIComments()->Add(new String("F5"));

// Retrieve the comment added to the cell F5
intrusive_ptr<IComment> comment = worksheet->GetIComments()->GetObjectByIndex(commentIndex);

// Set the comment note
comment->SetNote(new String("Hello Aspose!"));

// Set the font size
comment->GetIFont()->SetSize(14);

// Set the font weight
comment->GetIFont()->SetBold(true);

// Set the height in CM
comment->SetHeightCM(10);

// Set the width in CM
comment->SetWidthCM(2);

// Save the Excel file
workbook->Save(outDir->StringAppend(new String("ApplyFormattingToComment_out.xlsx")));