用查询批量导入EXCEL 时，获取EXCEL 表sheet名称

用查询的方式，批量导入EXCEL 到“库”时，通常会需要获取到EXCEL 表名。
DataTable shtNamTab = Oconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);

用   GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null) 来获取   表 名  的集合；

DataTable shtNamTab = Oconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);

 

            openFileDialog1.Title = "打开上报表";
            openFileDialog1.FileName = "";
            openFileDialog1.Filter = "ExcelFile|*.xlsx";
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                string ExPath = openFileDialog1.FileName;
                string ExConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + ExPath + ";Extended Properties='Excel 12.0; HDR=Yes; IMEX=1'";
                OleDbConnection Oconn = new OleDbConnection(ExConn);
                Oconn.Open();
              DataTable shtNam = Oconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
              string shtTbNam = shtNam.Rows[0]["Table_Name"].ToString();
              //MessageBox.Show(shtTbNam);
                this.dataGridView1.DataSource = shtNam;
                Oconn.Close();
            }