Docs HotXLS
Accueil Sommaire Aperçu

ClearContents-method

Clears the data from the range but leaves the formatting

Syntaxe

procedure ClearContents;

Exemple

This example clears the data from cells A1:G37 on sheet one but leaves the formatting intact 

Workbook.Worksheets[1].Range['A1', 'G37'].ClearContents;