Excel worksheets' names

[vasolis]

Hello all.

I have trouble listing all worksheet's names from an excel file.
I know that by using an OleDbConnection you can connect to an excel file and with a command like this:
select * from [sheet1$]
you can retrieve all data from sheet1, since sheet1 is considered as a table.

The problem is when I have multiple sheets how can I find all sheets' names?
For example if I want to Load an .xls file, I want a combo box to display all the sheets in order to choose from where to retrieve the data from.

Thanx in advance

 

[jmcilhinney]

The GetSchema method of the OleDbConnection class returns a DataTable that contains schema information about the collection of objects that you specify.

myComboBox.DisplayMember = "TABLE_NAME"
myComboBox.DataSource = myOleDbConnection.GetSchema("Tables")

 

[jmcilhinney]

Also, I moved this thread to a more appropriate forum.

 

[vasolis]

GetSchema method

Thanx for your reply

This method is new in the .NET Framework version 2.0, according to this page: http://msdn2.microsoft.com/en-us/library/ms135981.aspx

I use .NET framework v1.1 and I found that GetOleDbSchemaTable method does the appropriate job.

Thanx again