Skip to main content

ExcelGetCellIsBoolean

Structure​

ExcelGetCellIsBoolean(iRow,iCol)

Type​

Function

Description​

This function returns '1' if the indicated cell of the current sheet is a boolean or a formula that evaluates to a boolean, and '0' if not.

Parameters​

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(ExcelGetCellIsBoolean(1,1)) 'Returns "0"
  ExcelSetCellAsBoolean(1,1,true)
  ShowMessage(ExcelGetCellIsBoolean(1,1)) 'Returns "1"
Except
  ShowMessage(LastExceptionMessage)
End Try