.net导入Excel 获取工作表名

（1）
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("/") + "Stu2009-10-15.xls" + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
            OleDbConnection objConn = new OleDbConnection(strConn);       
            List <string> SheetNameList = new List <string>();         
                objConn.Open();
                DataTable dtExcelSchema = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
                string SheetName = "";
                for (int i = 0; i < dtExcelSchema.Rows.Count; i++)
                {
                    SheetName = dtExcelSchema.Rows[i]["TABLE_NAME"].ToString();
                    SheetNameList.Add(SheetName);
                }
                GridView1.DataSource =SheetNameList;
                GridView1.DataBind();
----------------------------------------------------------------------------------
(2).net 获取Excel所有工作表名称：

OleDbConnection oleConn = new OleDbConnection();
oleConn.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;data source=D:\\Data.xls;Extended Properties=Excel 8.0;";
oleConn.Open();
DataTable dtOle = oleConn.GetSchema("Tables");
DataTableReader dtReader = new DataTableReader(dtOle);

while (dtReader.Read())
{
MessageBox.Show(dtReader["Table_Name"]);
}
dtReader = null;
dtOle = null;
oleConn.Close();
----------------------------------------------------------------------------------------------------
(3)

public DataSet ExcelToDS(string Path)     {         string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";         OleDbConnection conn = new OleDbConnection(strConn);         conn.Open();         string strExcel = "";         OleDbDataAdapter myCommand = null;         DataSet ds = null;                  DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });         string SheetName = dt.Rows[0]["TABLE_NAME"].ToString(); //这里就是取得表的名字了         strExcel = "select * from [" + SheetName + "]";         myCommand = new OleDbDataAdapter(strExcel, strConn);         ds = new DataSet();         myCommand.Fill(ds, "table1");         myCommand.Dispose();         conn.Close();         return ds;     }