Clear Comments from XLSB Document Online or Manage via Java

Remove XLSB Annotations Online

1. Import XLSB file to delete comments by uploading it
2. Do it by clicking inside the drop area via drag and drop of annotation app
3. Depending on the size of XLSB file and internet speed wait for few seconds
4. Click the ‘Remove’ button to clear comments
5. Download the file instantly

Remove XLSB Document Comments via Java

1. Add library reference to Java project
2. Load Document via Workbook class object
3. Select the specific Worksheet
4. Get all comments from the using getComments()
5. Get all Threaded comments via getThreadedComments
6. Use removeAt to remove comments and authors respectively
7. Call the save method to save the file

Update Threaded XLSB Comments

1. Add library reference to Java project
2. Load Document via Workbook class object
3. Get the sepecific Worksheet
4. Get the threaded comment using getComments().getThreadedComments(Index).get(Index)
5. Use setNotes method to update the comment
6. Call the save method to save the file

Add Comments via Java

1. Add library reference to Java project
2. Create Document via Workbook class object
3. Get the sepecific Worksheet
4. Add comment index via getComments().add
5. Use the setNotes method to add comment
6. Call the save method to save the file with added comments

Java Library to Annotate XLSB Files

There are alternative options to install “ Aspose.Cells for Java ” or “ Aspose.Total for Java ” onto your system. Our Java package is designed to be cross-platform, compatible with JVM implementations on various operating systems such as Microsoft Windows, Linux, macOS, Android, and iOS. Please choose one that resembles your needs and follow the step-by-step instructions:

• Install Aspose.Cells for Java
• Or from Maven
• Step by Step Instructions

System Requirements

• J2SE 6.0 (1.6)
• J2SE 7.0 (1.7) or above