Spire.XLS API

XlsRange Clear Method (ExcelClearOptions)

Clears the cell based on clear options.

Examples

The following code illustrates how to clear the Range with clear options:

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Clears the Range C2 with its clear options</para><para>worksheet.Range["C2"].Clear(ExcelClearOptions.ClearAll);</para><para>//Save to file</para><para>workbook.SaveToFile("ClearContents.xlsx");</para>

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

Syntax

C++

ASP.NET

Copy

public void Clear(
	ExcelClearOptions option
)

Public Sub Clear ( 
	option As ExcelClearOptions
)

public:
virtual void Clear(
	ExcelClearOptions option
) sealed

abstract Clear : 
option : ExcelClearOptions -> unit 
override Clear : 
option : ExcelClearOptions -> unit

Parameters

option: Type: Spire.Xls ExcelClearOptions
Represents the clear options.

Implements

IXLSRange Clear(ExcelClearOptions)

Reference

XlsRange Class

Clear Overload

Spire.Xls.Core.Spreadsheet Namespace

XlsRange AddLanguageSpecificTextSet("LST112A0ED3_0?cpp=::|nu=."); Clear Method (ExcelClearOptions)

Parameters

Implements

Reference

XlsRange Clear Method (ExcelClearOptions)