Table of Contents

Method Clear

Namespace
DocWright.Formats.Xlsx
Assembly
DocWright.Formats.Xlsx.dll

Clear(int, int)

Empties a cell: its value and its formula go, and the cell stays for its format.

public void Clear(int row, int column)

Parameters

row int

The one-based row.

column int

The one-based column.

Exceptions

ArgumentOutOfRangeException

The row or the column is outside the worksheet grid.

InvalidOperationException

The sheet is not a worksheet.

UnsupportedFeatureException

The cell is part of an array formula entered over several cells, or is a header or totals cell of a table.

InvalidDocumentException

The sheet's part is malformed.

Clear(string)

Empties a cell by its reference. See Clear(int, int).

public void Clear(string reference)

Parameters

reference string

The reference, such as B4.

Exceptions

ArgumentNullException

reference is null.

ArgumentException

reference is not a cell reference inside the worksheet grid.

InvalidOperationException

The sheet is not a worksheet.

UnsupportedFeatureException

The cell is part of an array formula entered over several cells, or is a header or totals cell of a table.

InvalidDocumentException

The sheet's part is malformed.