PPTX
DOCX
XLSX
PDF
ODP
XLSM
Add or Delete Annotation from XLSM via Java
Build your own Java apps to manipulate comments & authors in document files using server-side APIs.
Aspose.Cells for Java
Overview
How to Annotate XLSM File Using Java
In order to annotate XLSM file, we’ll use
API which is a feature-rich, powerful and easy to use annotation API for Java platform. You can download its latest version directly from
and install it within your Maven-based project by adding the following configurations to the pom.xml.
Repository
<repository>
<id>AsposeJavaAPI</id>
<name>Aspose Java API</name>
<url>https://repository.aspose.com/repo/</url>
</repository>
Dependency
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>version of aspose-cells API</version>
<classifier>jdk17</classifier>
</dependency>
Steps to Add or Delete Annotation from XLSM via Java
- Load XLSM file using Workbook class
- Select the relevant sheet
- Get all comments by CommentCollection
- Call RemoveAt with the Cell Id to remove it
- Save the workbook before & after calling RemoveAt method to compare
System Requirements
Aspose.Cells for Java supports on all major platforms and Operating Systems. Please make sure that you have the following prerequisites.
- Microsoft Windows or a compatible OS with Java Runtime Environment for JSP/JSF Application and Desktop Applications.
- Get latest version of Aspose.Cells for Java directly from Maven.
Delete Annotations from XLSM - Java
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "ThreadedCommentsSample.xlsm");
//Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
CommentCollection comments = worksheet.getComments();
ThreadedCommentCollection threadedComments = worksheet.getComments().getThreadedComments("I4");
ThreadedCommentAuthor author = threadedComments.get(0).getAuthor();
comments.removeAt("I4");
ThreadedCommentAuthorCollection authors = workbook.getWorksheets().getThreadedCommentAuthors();
authors.removeAt(authors.indexOf(author));
workbook.save(dataDir + "ThreadedCommentsSample_Out.xlsm");