PPTX DOCX XLSX PDF ODP
Add or Delete Annotation from XLSB via Java
Build your own Java apps to manipulate comments & authors in document files using server-side APIs.
How to Annotate XLSB File Using Java
In order to annotate XLSB 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> <id>AsposeJavaAPI</id> <name>Aspose Java API</name> <url>https://repository.aspose.com/repo/</url> </repository>
<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 XLSB via Java
- Load XLSB 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
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 XLSB - Java
// Instantiating a Workbook object Workbook workbook = new Workbook(dataDir + "ThreadedCommentsSample.xlsb"); //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.xlsb");