Excel Heders collected using OLEDB; ExcelWorksheet wBook = excelWorkbooksOpen ' Here see MSDN on how to use and pass in the variable for name of the file wSheet = wBookActiveSheet() For Each wSheet In wBookSheets MsgBox(wSheetName) ' replace with say populating variable (s) Next You can also loop through the sheets with the OLEDB provider, but the order of sheets is In C# net , you can get a reference of sheets of a excel file Here is a small code snippet, Add reference of MicrosoftofficeInteropexcel
How To Search By Worksheet Name In Excel