Re: How do I find all worksheets in Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Brian,
"Brian Kitt" <BrianKitt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

BK> I created an ODBC connection to an Excel work***. I can query
BK> worksheets without any problem. I would like to be able to find
BK> all worksheets in the workbook. Is there an object to query (using
BK> ODBC) that gives me the names of all of the worksheets? In my
BK> application, the name of the *** is significant, so just querying
BK> 'sheet1' 'sheet2' is not sufficient.

MSDN recommends using SQLTables as described in as follows:

rc = SQLTables(hstmt,0,0,0,0,0,0,
(SQLCHAR*)"SYSTEM TABLE",SQL_NTS);

But due to an old bug in the Excel driver, this does not work. You are only
given the possibility of enumerating tables defined within worksheets, aka
named regions, by specifying "TABLE" as the table type.
--
Sincerely,
Dmitri Ivanov
Common Lisp ODBC interface - www.ystok.ru



.

Quantcast