Retrieving Excel Sheet Names from Excel Workbook

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

Hello,

I am retreiving Excel sheet names from a Excel workbook.

I am using GetOleDBSchemaTable for it.

I see a strange behaviour sometimes that when I retrieve the names from a
particular Excel file, it returns all 3 sheets correctly with right names
and also returns a additional sheetname with name as "Sheet1$".

Can anyone please tell me if this is a bug or I am doing something wrong.

Any help is appreciated.

Regards,
Rohit
 
¤ Hello,
¤
¤ I am retreiving Excel sheet names from a Excel workbook.
¤
¤ I am using GetOleDBSchemaTable for it.
¤
¤ I see a strange behaviour sometimes that when I retrieve the names from a
¤ particular Excel file, it returns all 3 sheets correctly with right names
¤ and also returns a additional sheetname with name as "Sheet1$".
¤
¤ Can anyone please tell me if this is a bug or I am doing something wrong.

It's not a bug. If you use data access to create a table in Excel you will get an additional table
name w/o the dollar sign symbol. Otherwise you have to reference Excel tables with the dollar sign
symbol by default.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top