Manage Microsoft® Excel File Annotations via C++
Add or remove simple notes for annotation or comments within C++ based applications.
C++ Excel API provides support to manage annotations at cell level by adding, accessing and removing comments. API provides Comment and CommentCollection as well as GetComments() for handling comments in all aspects. Supported Excel formats include ODS, XLS, XLSX, XLSB and XLSM.
Excel Files Data Annotations
Manipulating Comments in Worksheets - It is not limited that how many comments a sheet has in MS Excel. One can insert as much as of application need. Process of inserting comments is, create Workbook class object to load an existing file and select worksheet where you want to add the comment. Get all of its comments using getComments(). Add the comment using Add(const char16_t* cellName) method. Get the cell index and use SetNote for inserting comments. Moreover, API is capable of removing all comments. Few of the methods are ClearComments() to Clears all comments in designer spreadsheet. Moreover, RemoveAt method to removes the element at a specified index or with specified name.