There are many examples using ADO.NET to query an Excel Workbook but they all have a limitation, you must know the worksheet name. This might work if you know the name of the worksheet, but what if you don't? If your program is dynamic and your sheet names differ for each Excel workbook, you need a way to extract the names of the sheets. The code example provides you with a way to retrieve the work sheet names.
The following method returns a string array containing the names of the sheets. The method also shows how to loop through the array. The method has one input parameter
excelFile which is the location of the Excel file.