PPTX DOCX XLSX PDF ODP
Aspose.Cells for .NET
XLSB

Add or Delete Annotation from XLSB via C#

Build your own .NET apps to manipulate comments & authors in document files using server-side APIs.

 

Aspose.Cells for .NET Aspose.Cells for .NET

Overview

How to Annotate XLSB File Using C#

In order to annotate XLSB file, we’ll use

Aspose.Cells for .NET

API which is a feature-rich, powerful and easy to use document manipulation API for C# platform. Open

NuGet

package manager, search for Aspose.Cells and install. You may also use the following command from the Package Manager Console.

Command


PM> Install-Package Aspose.Cells

Add or Delete Annotation from XLSB via C#

You need

aspose.cells.dll

to try the code in your environment.

  • Load XLSB file by creating an instance of Workbook
  • Add Comment to the Worksheet in a Cell
  • Call RemoveAt with the Cell Id to remove it
  • Save the workbook before & after calling RemoveAt method to compare

System Requirements

Aspose.Cells for .NET is supported on all major operating systems. Just make sure that you have the following prerequisites.

  • Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Mono or Xamarin Platforms.
  • Development environment like Microsoft Visual Studio.
  • Add reference to the Aspose.Cells for .NET DLL in your project.
 

Delete Annotations from XLSB - C#

// load an existing XLSB
var workbook = new Aspose.Cells.Workbook("template.xlsb");
// add comment to cell A1 of first worksheet
int commentIndex = workbook.Worksheets[0].Comments.Add("A1");
// access to comment object to set its text
var comment = workbook.Worksheets[0].Comments[commentIndex];
comment.Note = "This is my comment";
// save as XLSB file
workbook.Save("annotation-added.xlsx");
// remove comments on cell A1
workbook.Worksheets[0].Comments.RemoveAt("A1");
// save the book again to compare
workbook.Save("annotation-removed.xlsb");
view raw delete-annotations-from-xlsb.cs hosted with ❤ by GitHub
 

    • About Aspose.Cells for .NET API

    Aspose.Cells API can be used to create, edit, convert and render Microsoft Excel formats to different formats. Moreover, it can be used for comprehensive charting, scalable reporting and reliable calculations within software applications. Aspose.Cells is a standalone API and it does not require any software like Microsoft or OpenOffice.

    Remove Annotation from XLSB via Online App

    Other Supported Annotation Formats

    Using C#, one can easily annotate other formats including.

    ODS (OpenDocument Spreadsheet File)
    XLS (Excel Binary Format)
    XLSM (Spreadsheet File)
    XLSX (OOXML Excel File)