Skip to main content

ExcelSetCellAsNumber

Structure​

ExcelSetCellAsNumber(iRow,iCol,fValue)

Type​

Procedure

Description​

This procedure sets the indicated cell of the current sheet to the numeric value.

Parameters​

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

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

fValue = The number to set the cell to.

Example​

Try
  ExcelNewFile(3,"v2003")
  ExcelGetSheetByIndex(1)
  ShowMessage(ExcelGetCellIsNumber(1,1)) 'Returns "0"
  ExcelSetCellAsNumber(1,1,1.1)
  ShowMessage(ExcelGetCellIsNumber(1,1)) 'Returns "1"
Except
  ShowMessage(LastExceptionMessage)
End Try