Using Excel OleDb to get sheet names IN SHEET ORDER
Can you not just loop through the sheets from 0 to Count of names -1? that way you should get them in the correct order. Edit I noticed through the comments that there are a lot of concerns about using the Interop classes to retrieve the sheet names. Therefore here is an example using OLEDB … Read more