获取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());
        }