HotXLS-dokumentation Innehåll Startsida Översikt TGridToXLS IXLSWorkbook Startsida Innehåll Översikt

Clear metod

Clears the cells in the specified range

Syntax

procedure Clear;

Exempel

This example clears values, formulas, comments, and formatting from a temporary input area while leaving the rest of the worksheet unchanged Use ClearContents when only cell values should be removed
var InputArea: IXLSRange; begin InputArea := Workbook.Worksheets[1].Range['A1', 'G37']; InputArea.Clear; InputArea.Cells[1, 1].Value := 'Ready for new data'; end;

Clear metod

Syntax

Exempel

Se även