使用Excel OleDb获取工作表名称IN SHEET ORDER(Using Excel OleDb to get sheet names IN SHEET ORDER)

 我正在使用OleDb从excel工作簿中读取许多工作表。 
 
 我需要阅读表格名称，但是我们需要按照它们在电子表格中定义的顺序; 所以如果我有一个这样的文件; 
 
|_____|_____|____|____|____|____|____|____|____|
|_____|_____|____|____|____|____|____|____|____|
|_____|_____|____|____|____|____|____|____|____|
\__GERMANY__/\__UK__/\__IRELAND__/
 
 然后我需要得到字典 
 
1="GERMANY", 
2="UK", 
3="IRELAND"
 
 我试过使用OleDbConnection.GetOleDbSchemaTable() ，这给我的名字列表，但它按字母排序它们。 阿尔法排序意味着我不知道特定名称对应的哪个表格编号。 所以我得到 
 
GERMANY, IRELAND, UK
 
 这改变了UK和IRELAND的秩序。 
 
 我需要排序的原因是我必须让用户按名称或索引选择一系列数据; 他们可以要求“从德国到爱尔兰的所有数据”或“从表格1到表格3的数据”。 
 
 任何想法将不胜感激。 
 
 如果我可以使用办公室互操作课程，这很简单。 不幸的是，我不能因为互操作类在非交互式环境（如Windows服务和ASP.NET站点）中不能可靠地运行，所以我需要使用OLEDB。 

I'm using OleDb to read from an excel workbook with many sheets. 
 
I need to read the sheet names, but I need them in the order they are defined in the spreadsheet; so If I have a file that looks like this;
 
|_____|_____|____|____|____|____|____|____|____|
|_____|_____|____|____|____|____|____|____|____|
|_____|_____|____|____|____|____|____|____|____|
\__GERMANY__/\__UK__/\__IRELAND__/
 
Then I need to get the dictionary
 
1="GERMANY", 
2="UK", 
3="IRELAND"
 
I've tried using OleDbConnection.GetOleDbSchemaTable(), and that gives me the list of names, but it alphabetically sorts them. The alpha-sort means I don't know which sheet number a particular name corresponds to. So I get;
 
GERMANY, IRELAND, UK
 
which has changed the order of UK and IRELAND. 
 
The reason I need it to be sorted is that I have to let the user choose a range of data by name or index; they can ask for 'all the data from GERMANY to IRELAND' or 'data from sheet 1 to sheet 3'.
 
Any ideas would be greatly appreciated.
 
if I could use the office interop classes, this would be straightforward. Unfortunately, I can't because the interop classes don't work reliably in non-interactive environments such as windows services and ASP.NET sites, so I needed to use OLEDB.

原文：https://stackoverflow.com/questions/1164698