GroupDocs.Annotation for Net API is a library that allows you to add annotations to PDF, Word and other documents on Mac, Windows or Ubuntu. GroupDocs.Annotation for Net is a native Net API for managing annotations with comprehensive support for creating, adding, editing, deleting, extracting and exporting annotations from images and various other documents. The full list of supported document formats you could see on this page. This library allows you to work not only with XLSB document but also with many other types documents such as Word, Excel, PowerPoint, Outlook emails, Visio, Adobe, OpenDocument, OpenOffice, Photoshop, AutoCad and many others. The GroupDocs.Annotation for Net API allows you to create and add new notes, edit annotations, extract comments, annotations, and remove them from documents. The library supports 13 different annotation types, including Text, Polyline, Area, Underline, Point, Watermark, Arrow, Ellipse, Text Replacement, Distance, Text Field, Resource Redaction in PDF, HTML, Microsoft Word documents, spreadsheets, diagrams, presentations, drawings, images and many other file formats. The example (please see below) demonstrates working with XLSB document, in this example you could see the main steps of how to work with GroupDocs.Annotation: Setup a license, open a document you want to work with, creating an annotation, adding data objects to set annotation properties according to your requirements and saving the result to the needed place. Also you could have a look more detailed on the supported features on our github page, or in our product documentation.
GroupDocs.Annotation makes it easy for Net developers to add various annotation types to XLSB files within any Net-based application by implementing a few easy steps.
GroupDocs.Annotation for Net APIs are supported on all major platforms and operating systems. Before executing the code below, please make sure that you have the following prerequisites installed on your system.
//Add text field annotation to the document from local disk
using (Annotator annotator = new Annotator("input.bmp"))
{
TextFieldAnnotation textField = new TextFieldAnnotation
{
BackgroundColor = 65535,
Box = new Rectangle(100, 100, 100, 100),
CreatedOn = DateTime.Now,
Text = "Some text",
FontColor = 65535,
FontSize = 12,
Message = "This is text field annotation",
Opacity = 0.7,
PageNumber = 0,
PenStyle = PenStyle.Dot,
PenWidth = 3,
FontFamily = "Arial",
TextHorizontalAlignment = HorizontalAlignment.Center,
Replies = new List
{
new Reply
{
Comment = "First comment",
RepliedOn = DateTime.Now
},
new Reply
{
Comment = "Second comment",
RepliedOn = DateTime.Now
}
}
};
annotator.Add(textField);
annotator.Save("result.bmp");
}
GroupDocs.Annotation makes it easier for Net developers to remove annotation details from XLSB files within any Net-based application by implementing a few easy steps.
// 1- How to remove annotation from document using annotation index
using (Annotator annotator = new Annotator("result.bmp"))
{
annotator.Remove(0);
annotator.Save("removed.bmp");
}
// 2- How to remove annotation from document using annotation object
using (Annotator annotator = new Annotator("result.bmp"))
{
var tmp = annotator.Get();
annotator.Remove(tmp[0]);
annotator.Save("removed.bmp");
}
// 3- How to remove some annotations from document using list of ID’s
using (Annotator annotator = new Annotator("result.bmp"))
{
var idList = new List{1, 2, 3};
annotator.Remove(idList);
annotator.Save("removed.bmp");
}
// 4- How to remove some annotations from document using list of annotations
using (Annotator annotator = new Annotator("result.bmp"))
{
var tmp = annotator.Get();
annotator.Remove(tmp);
annotator.Save("removed.bmp");
}
GroupDocs.Annotation makes it easier for Net developers to update various annotation properties from XLSB files within any Net-based application by implementing a few easy steps.
// open annotated document
using (Annotator annotator = new Annotator("result.bmp"))
{
//assuming we are going to change some properties of existing annotation
AreaAnnotation updated = new AreaAnnotation
{
// It's important to set existed annotation Id
Id = 1,
BackgroundColor = 255,
Box = new Rectangle(0, 0, 50, 200),
CreatedOn = DateTime.Now,
Message = "This is updated annotation",
Replies = new List
{
new Reply
{
Comment = "Updated first comment",
RepliedOn = DateTime.Now
},
new Reply
{
Comment = "Updated second comment",
RepliedOn = DateTime.Now
}
}
};
// update annotation
annotator.Update(updated);
annotator.Save("result.bmp");
}
GroupDocs.Annotation makes it easy for Net developers to annotate documents and extract annotation information from XLSB files within any Net-based application by implementing a few easy steps.
// for using this example input file ("annotated.bmp") must be with annotations
using (Annotator annotator = new Annotator("annotated.bmp"))
{
List annotations = annotator.Get();
XmlSerializer formatter = new XmlSerializer(typeof(List));
using (FileStream fs = new FileStream("annotations.xml", FileMode.Create))
{
fs.SetLength(0);
formatter.Serialize(fs, annotations);
}
}
Add, remove, edit and extract annotations to XLSB file right now by visiting GroupDocs.Annotation Live Demos website. The live demo has the following benefits
No need to download API
No need to write any code
Just upload the source file
Get download link to save the file
XLSB file format specifies the Excel Binary File Format, which is a collection of records and structures that specify Excel workbook content. The content can include unstructured or semi-structured tables of numbers, text, or both numbers and text, formulas, external data connections, charts and images. Unlike XLSX (which is based on Open XML file format), the XLSB represents binary Excel workbook file. XLSB files can be read and written to faster which makes them useful for working with large files. XLSB is seldom used to store workbooks as XLSX (and previously XLS) are the most common user selected file formats for saving workbooks. It can be opened by Microsoft Office 2007 and above.
Read More About XLSB File FormatUpdate annotation properties from some of the popular file formats as stated below.
(Adobe Portable Document Format)
(Microsoft Word Document)
(Microsoft Word Macro-Enabled Document)
(Microsoft Word Open XML Document)
(Microsoft Word Document Template)
(Word Open XML Document Template)
(Rich Text Document)
(Open Document Text)
(Microsoft Excel Binary File Format)
(Microsoft Excel Open XML Spreadsheet)
(Microsoft Excel Macro-Enabled Spreadsheet)
(Microsoft Excel Binary Worksheet)
(Open Document Spreadsheet)
(PowerPoint Presentation)
(PowerPoint Open XML Presentation)
(PowerPoint Open XML Slide Show)
(Microsoft PowerPoint Template)
(Microsoft PowerPoint Presentation)
(Microsoft PowerPoint 97-2003 Slide Show)
(OpenDocument Presentation)
(HyperText Markup Language)
(Tagged Image File Format)
(JPEG Image)
(Portable Network Graphic)
(E-mail Message)
(Microsoft Outlook E-mail Message)
(Microsoft Visio 2003-2010 Drawing)
(Microsoft Visio Drawing)
(Microsoft Visio 2003-2010 Stencil)
(Microsoft Visio 2013 Stencil)
(Autodesk Design Data Formats)
(AutoCAD Drawing Interchange)
(Digital Imaging and Communications in Medicine)
(Windows Metafile)
(Enhanced Metafile Format)