Get Excel sheet names, named ranges and reference tables
The attached VS2012 solution contains a class project that can be used in your projects to get sheet names, named ranges and reference tables via Excel automation. The test project is a simple console app.
Note that you can get sheet names via OleDb but the sheetnames come back pre-sorted while using Excel automation we get them in ordinal position.