.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;
    }