I have read from an Excel sheet before by setting up a datasource via CF Administrator. I can read from my original Excel spreadsheet; however, it was created by me w/o much formatting. I now have to read from a sheet that has much more formatting (i.e. I could reference a column by "Cat" because I named the column as such; however, the new format calls for "I. Category Identifier:").
SELECT * FROM [Sheet1B4:N76]
IN '#fullPath#' 'EXCEL 5.0;'
From this query, I referenced values as, #query.Cat#; however, I'm not sure how to reference the newly formated column names. BTW, this is for a client, and I'm certain they don't want to purchase any custom tags.