Get Excel Sheet Names w/o Excel Object

[bjd4jc]

I am trying to get the names of all the sheets in an excel spreadsheet without using the Excel object Model.

In VB6 I would use ADOX to do this. What direction should I take to do this without the use of the excel object model in .NET?

 

[bjd4jc]

I figured it out. I finally found it in the vb Help.

Here is the code to return them into a datatable

Public Function GetTables(ByVal conn As OleDb.OleDbConnection) As DataTable
    Dim schemaTable As DataTable = conn.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, _
        New Object() {Nothing, Nothing, Nothing, "TABLE"})
        
    Return schemaTable
End Function