Getting sheet number as ordered in Excel, not alphabetical about linqtoexcel

[Magikos]

I didn't know it did that, your comment helped me fix an error I was having.

I second this request. Index should be the page index, regardless of the name.

[paulyoder]

I don't believe that's possible because OLEDB is used to get the list of sheet names, and it returns it in alphabetical order.

Let me know if anyone finds a solution though.

[Magikos]

From my research, unfortunately it seems Paul is correct. :-(

OleDB does not support this ability.

[chakaroff]

http://stackoverflow.com/questions/1164698/using-excel-oledb-to-get-sheet-names-in-sheet-order - does this work?

[paulyoder]

The StackOverflow answer is retrieving the sheet names the exact same way LinqToExcel does, and it only returns it in alphabetical order. See this comment on the answer: http://stackoverflow.com/questions/1164698/using-excel-oledb-to-get-sheet-names-in-sheet-order#comment1556381_1165281