ExcelSetCellEmpty

Structure

ExcelSetCellEmpty(iRow,iCol)

Type

Procedure

Description

This procedure clears the indicated cell of the current sheet.

Parameters: 2

iRow = The row of the cell. 1 is the top row.

iCol = The column of the cell. 1 corresponds to column A

Example

Try

ExcelNewFile(3,"v2003")

ExcelGetSheetByIndex(1)

ShowMessage(ExcelGetCellIsEmpty(1,1)) 'Returns "1"

ExcelSetCellAsNumber(1,1,1.1)

ShowMessage(ExcelGetCellIsEmpty(1,1)) 'Returns "0"

ExcelSetCellEmpty(1,1)

ShowMessage(ExcelGetCellIsEmpty(1,1)) 'Returns "1"

Except

ShowMessage(LastExceptionMessage)

End Try