C#如何擷取Excel工作薄中Sheet頁(工作表)名集合

#region 擷取Excel工作薄中Sheet頁(工作表)名集合   
02./// <summary>    
03./// 擷取Excel工作薄中Sheet頁(工作表)名集合   
04./// </summary>    
05./// <param name="excelFile">Excel檔案名稱及路徑,EG:C:\Users\JK\Desktop\匯入測試.xls</param>    
06./// <returns>Sheet頁名稱集合</returns>    
07.private String[] GetExcelSheetNames(string fileName)  
08.{  
09.    OleDbConnection objConn = null;  
10.    System.Data.DataTable dt = null;  
11.    try  
12.    {  
13.        string connString=string.Empty;  
14.        string FileType =fileName.Substring(fileName.LastIndexOf("."));  
15.        if (FileType == ".xls")    
16.         connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +  
17.            "Data Source=" + fileName + ";Extended Properties=Excel 8.0;";  
18.        else//.xlsx   
19.            connString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + fileName + ";" + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\"";    
20.        // 建立連線物件    
21.        objConn = new OleDbConnection(connString);  
22.        // 開啟資料庫連接    
23.        objConn.Open();  
24.        // 得到包含資料架構的資料表    
25.        dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);  
26.        if (dt == null)  
27.        {  
28.            return null;  
29.        }  
30.        String[] excelSheets = new String[dt.Rows.Count];  
31.        int i = 0;  
32.        // 添加工作表名稱到字串數組    
33.        foreach (DataRow row in dt.Rows)  
34.        {  
35.            string strSheetTableName = row["TABLE_NAME"].ToString();  
36.            //過濾無效SheetName   
37.            if (strSheetTableName.Contains("$")&&strSheetTableName.Replace("'", "").EndsWith("$"))  
38.            {  
39.                excelSheets[i] = strSheetTableName.Substring(0, strSheetTableName.Length - 1);  
40.            }                     
41.            i++;  
42.        }  
43.        return excelSheets;  
44.    }  
45.    catch (Exception ex)  
46.    {  
47.        MessageBox.Show(ex.ToString());  
48.        return null;  
49.    }  
50.    finally  
51.    {  
52.        // 清理    
53.        if (objConn != null)  
54.        {  
55.            objConn.Close();  
56.            objConn.Dispose();  
57.        }  
58.        if (dt != null)  
59.        {  
60.            dt.Dispose();  
61.        }  
62.    }  
63.}  
64.#endregion 

本文URL：http://www.bianceng.cn/Programming/csharp/201410/45597.htm