Skip to main content

ExcelGetCellAsBoolean

Structure​

ExcelGetCellAsBoolean(iRow,iCol)

Type​

Function

Description​

This function returns the equivalent to the boolean value of the cell or formula result, if possible. '0' is returned for false, '1' for true. It will throw an exception otherwise.

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