HotXLS Docs
Home Contents Overview

ClearContents method

Clears the data from the range but leaves the formatting.

Syntax

procedure ClearContents;

Example

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

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