English
  1. Products
  2.   Aspose.Total
  3.   Android via Java
  4.   Annotate
  5.   Excel

Clear Comments from Excel Document Online or Manage via Android Apps

Develop powerful Android based Excel document annotation utility application. Code listed for managing comments of Excel file.

Excel Annotate via C# .NET Excel Annotate via Java Excel Annotate via C++

Download

Remove Excel Annotations Online

  1. Import Excel 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 Excel file and internet speed wait for few seconds
  4. Click the ‘Remove’ button to clear comments
  5. Download the file instantly

Remove Excel Document Comments via Android App API

  1. Add library reference to Android 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
 

Code : Remove Comments from Excel Document

Workbook workbook = new Workbook(dataDir + "ExcelDocumentwithComments.xlsx");
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 + "removedcomments.xlsx");
view raw remove-comments-from-excel-file.java hosted with ❤ by GitHub
 

Update Threaded Excel Comments

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

Add Comments via Android App API

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

Code : Update Threaded Comment of Excel File

Workbook workbook = new Workbook(dataDir + "ThreadedCommentsFile.xlsx");
Worksheet worksheet = workbook.getWorksheets().get(0);
ThreadedComment comment = worksheet.getComments().getThreadedComments("A1").get(0);
comment.setNotes("Updated Comment");
workbook.save(dataDir + "updateThreadedComments.xlsx");
view raw update-threaded-comments-in-excel.java hosted with ❤ by GitHub
 
 

Code: Adding Comments

Workbook workbook = new Workbook();
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
int commentIndex = worksheet.getComments().add("F5");
com.aspose.cells.Comment comment = worksheet.getComments().get(commentIndex);
comment.setNote( "Hello Aspose!");
workbook.save(dataDir + "book1.out.xls");
view raw add-comments-to-excel-file.java hosted with ❤ by GitHub
 
 

Develop Excel Document Annotation Android App

Need to develop an android based Excel annotation app or utility to provide feedback, make suggestions, or collaborate with others on the document? With Aspose.Cells for Android via Java a child API of Aspose.Total for Android via Java , any android developer can integrate the above API code within its document annotation application. Powerful android library allows programming any document annotation solution. Moreover it can support many popular formats including Excel format.

Android API to Annotate Excel Files

System Requirements

  • Android OS 2.0 or above.
  • Java package is cross-platform and runs on all operating systems with JVM implementation.

For more details please refer to [Product Documentation](https://docs.aspose.com/cells/java/system-requirements/).

Explore Annotate File Options with Android

Annotate CSV Files (Comma Seperated Values)
Annotate DOC Files (Microsoft Word Binary Format)
Annotate DOCM Files (Microsoft Word 2007 Marco File)
Annotate DOCX Files (Office 2007+ Word Document)
Annotate DOT Files (Microsoft Word Template Files)
Annotate DOTM Files (Microsoft Word 2007+ Template File)
Annotate DOTX Files (Microsoft Word Template File)
Annotate Excel Files
Annotate ODP Files (OpenDocument Presentation Format)
Annotate ODS Files (OpenDocument Spreadsheet)
Annotate ODT Files (OpenDocument Text File Format)
Annotate PDF Files (Portable Document Format)
Annotate POTM Files (Microsoft PowerPoint Template File)
Annotate POTX Files (Microsoft PowerPoint Template Presentation)
Annotate Powerpoint Files
Annotate PPS Files (PowerPoint Slide Show)
Annotate PPSM Files (Macro-enabled Slide Show)
Annotate PPSX Files (PowerPoint Slide Show)
Annotate PPT Files (PowerPoint Presentation)
Annotate PPTM Files (Macro-enabled Presentation File)
Annotate PPTX Files (Open XML presentation Format)
Annotate RTF Files (Rich Text Format)
Annotate TSV Files (Tab-separated Values)
Annotate TXT Files (Text Document)
Annotate Word Files
Annotate XLS Files (Microsoft Excel Binary Format)
Annotate XLSB Files (Excel Binary Workbook)
Annotate XLSM Files (Macro-enabled Spreadsheet)
Annotate XLSX Files (Open XML Workbook)
Annotate XLT Files (Excel 97 - 2003 Template)
Annotate XLTM Files (Excel Macro-Enabled Template)
Annotate XLTX Files (Excel Template)