HotXLS Docs

ClearComments method

Clears all cell comments from the specified range.

Syntax

procedure ClearComments;

Example

This example removes review comments from a report body before the workbook is delivered to users. Cell values and formatting remain in place.

var
  ReportBody: IXLSRange;
begin
  ReportBody := Workbook.Sheets[1].Range['A2', 'H40'];
  ReportBody.ClearComments;
  Workbook.SaveAs('C:\Reports\customer-copy.xls');
end;

See also