ExcelComment Class

Represents a comment object used by Comment in the worksheet.

Inheritance Hierarchy

SystemObject
GemBox.SpreadsheetExcelComment

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 43.0.35.1005

Syntax

public class ExcelComment

Public Class ExcelComment

The ExcelComment type exposes the following members.

Properties

	Name	Description
	Author	Gets or sets comment author.
	BottomRightCell	Gets or sets the bottom right anchor cell for the comment shape.
	Exists	If comment exists returns true, otherwise returns false.
	IsVisible	Gets or sets a value indicating whether this instance is visible.
	Text	Gets the comment text assigned to excel cell
	TopLeftCell	Gets or sets the top left anchor cell for the comment shape.

Methods

	Name	Description
	Equals	Determines whether the specified Object is equal to this ExcelComment instance. (Overrides ObjectEquals(Object).)
	GetCharacters(Int32)	Returns a FormattedCharacterRange object that represents a range of characters within the comment text. The range starts at a specified character position. Supported in XLSX only.
	GetCharacters(Int32, Int32)	Returns a FormattedCharacterRange object that represents a range of characters within the comment text. The range starts at a specified character position and has a specified length. Supported in XLSX only.
	GetHashCode	Returns a hash code for this ExcelComment instance. (Overrides ObjectGetHashCode.)

Operators

	Name	Description
	Equality	Determines whether first and second ExcelComments are equal.
	Inequality	Determines whether first and second ExcelComments are not equal.

Remarks

Supported only in xlsx.

Examples

Following code demonstrates how to use comments. It shows next features:

excelFile.Worksheets[0].Cells[0, 0].Comment.Text = "comment1";
excelFile.Worksheets[0].Cells[0, 0].Comment.IsVisible = false;

excelFile.Worksheets(0).Cells(0, 0).Comment.Text = "comment1"
excelFile.Worksheets(0).Cells(0, 0).Comment.IsVisible = False