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 Clear Method

Clears worksheet data. Removes all formatting and merges.

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 Clear()

Sub Clear

void Clear()

abstract Clear : unit -> unit

Reference

IWorksheet Interface

Spire.Xls.Core Namespace

IWorksheet AddLanguageSpecificTextSet("LSTDCDAD2A2_0?cpp=::|nu=."); Clear Method

Reference

IWorksheet Clear Method