Manage Microsoft® Excel File Annotations via Java
Insert simple notes for annotation or delete Excel spreadsheet cell level comments within Java based applications.
Java Excel API provides support to manage annotations at cell level by adding, accessing and deleting comments. API provides Comment , CommentCollection , ThreadedComment and ThreadedCommentCollection for handling comments in all aspects. Supported file formats include ODS, XLS, XLSX, XLSB and XLSM.
Excel Files Data Annotations
Managing Comments in Worksheets - There is not any limit that how many comments a sheet has in MS Excel. One can add as much as of application requirement. Process of adding comments is, create Workbook class object or load an existing file using Workbook class. Access all of its comments using getComments(). Get the cell index and use setNote for inserting comments. Moreover, API is capable of removing all comments.