try
            {   
           
                openFileDialog1.ShowDialog();

                oledbconn1.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source="+openFileDialog1.FileName+";Extended Properties=Excel 8.0;Persist Security Info=False";

                oledbconn1.Open(); 

                DataTable dt = oledbconn1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] {null, null, null, "TABLE"}); 

                foreach (DataRow dr in dt.Rows) 
                { 
                
                    comboBox1.Items.Add((String)dr["TABLE_NAME"]);
                } 

                

                //MessageBox.Show("打开成功！","提示！",MessageBoxButtons.OK,MessageBoxIcon.Information );

            }

            catch(Exception)    //catch(Exception ex)
            {
                
                MessageBox.Show("Excel文件不能被打开！" ,"错误",MessageBoxButtons.OK,MessageBoxIcon.Error );
            
            }
           


            textBox1.Text=openFileDialog1.FileName;
可以看看我的代码,把当前打开的EXCEL文件中所有的表都填写到comboBox控件的下拉列表中!不知对你是否有用!

谢谢！！！！