Spire.XLS API

Spire.XLS namespace

Spire.Xls.Core

IWorksheet Interface

IWorksheet Methods

AutoFitColumn Method

AutoFitRow Method

CheckExistence Method

Clear Method

ClearData Method

ColumnWidthToPixels Method

CopyToClipboard Method

CreateNamedRanges Method

DeleteColumn Method

DeleteRow Method

GetBoolean Method

GetColumnWidthPixels Method

GetDefaultColumnStyle Method

GetDefaultRowStyle Method

GetError Method

GetFormula Method

GetFormulaBoolValue Method

GetFormulaErrorValue Method

GetFormulaNumberValue Method

GetFormulaStringValue Method

GetNumber Method

GetRowHeightPixels Method

GetText Method

InsertArray Method

InsertDataColumn Method

InsertDataTable Method

InsertDataView Method

IsColumnVisible Method

IsRowVisible Method

MoveWorksheet Method

PixelsToColumnWidth Method

SetColumnWidthInPixels Method

SetDefaultColumnStyle Method

SetDefaultRowStyle Method

SetError Method

SetFormula Method

SetFormulaBoolValue Method

SetFormulaErrorValue Method

SetFormulaNumberValue Method

SetFormulaStringValue Method

SetNumber Method

SetRowHeightPixels Method

SetText Method

SetValue Method

Unprotect Method

IWorksheet ClearData Method

Clears worksheet. Only the data is removed from each cell.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

void ClearData()

Sub ClearData

void ClearData()

abstract ClearData : unit -> unit

Reference

IWorksheet Interface

Spire.Xls.Core Namespace

IWorksheet AddLanguageSpecificTextSet("LST44136F8D_0?cpp=::|nu=."); ClearData Method

Reference

IWorksheet ClearData Method