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 XLS 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 XLS 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 XLS 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 XLS 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 XLS 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 XLS 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 XLS 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
Files with XLS extension represent Excel Binary File Format. Such files can be created by Microsoft Excel as well as other similar spreadsheet programs such as OpenOffice Calc or Apple Numbers. File saved by Excel is known as Workbook where each workbook can have one or more worksheets. Data is stored and displayed to users in table format in worksheet and can span numeric values, text data, formulas, external data connections, images, and charts. Applications like Microsoft Excel lets you export workbook data to several different formats including PDF, CSV, XLSX, TXT, HTML, XPS, and several others. The XLS file format was replaced with a more open and structured format, XLSX, with the release of Microsoft Excel 2007. The latest versions still provide support for creating and reading XLS files, though XLSX is the first choice of use now.
Read More About XLS 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)