I have set up ODBC connections to my worksheet using the MS Excel driver.

That works. I am able to read my spreadsheet using SQL.

However, am I meant to be able to use Excel functions? What I'd really like is to determine the row as I am reading the source but I don't know the best approach.