获取excel表名。

 

string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + FileUpload1.PostedFile.FileName.ToString() + ";" +
"Extended Properties=Excel 8.0;";
        OleDbConnection objConn = new OleDbConnection(sConnectionString);
        try
        ...{
            objConn.Open();
            DataTable dt=objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            GridView1.DataSource = dt;
            GridView1.DataBind();
            //Response.Write(dt.Rows[0][1].ToString());
        }
        catch (Exception ex)
        ...{
            Response.Write(ex.ToString());
        }