HotXLS Docs

Comment property

Returns or sets a free-form note attached to a defined IXLSName. Read/write WideString

Syntax

property Comment: Widestring;

Remarks

The comment round-trips through the BIFF8 NAMECMT record and is preserved when the Workbook is saved as XLS. Set this property to an empty string to remove an existing comment

Example

This example adds a defined name and attaches a comment to it

var AName: IXLSName;
begin
  AName := Workbook.Names.Add('SalesTotal', '=Sheet1!$B$2');
  AName.Comment := 'Sum of quarterly sales figures';
end;