asp.net迴圈讀取excel工作表（sheet）名稱

asp.net迴圈讀取excel工作表（sheet）名稱

      OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;imex=1;hdr=no\";");
               objConn.Open();
               System.Data.DataTable dt = null;
               dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
               String[] excelSheets = new String[dt.Rows.Count];
int i = 0;
foreach (DataRow row in dt.Rows)
               {
                   Response.Write(row["TABLE_NAME"].ToString());
                   i++;
               }
if (objConn != null)
               {
                   objConn.Close();
                   objConn.Dispose();
               }
if (dt != null)
               {
                   dt.Dispose();
               }

註：path為實際路徑