OpenFileDialog openFileDialog = new OpenFileDialog();

            openFileDialog.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx";//过滤一下，只要表格格式的

            openFileDialog.InitialDirectory = "c:\\";

            openFileDialog.RestoreDirectory = true;

            openFileDialog.FilterIndex = 1;

            openFileDialog.AddExtension = true;

            openFileDialog.CheckFileExists = true;

            openFileDialog.CheckPathExists = true;

            openFileDialog.ShowHelp = true;

            if (openFileDialog.ShowDialog() == DialogResult.OK)

            {

                string fileName = openFileDialog.FileName;

                string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + openFileDialog.FileName + ";Extended Properties=Excel 12.0";

                OleDbConnection conn = new OleDbConnection(strConn);

                conn.Open();

                string strExcel = "";

                OleDbDataAdapter myCommand = null;

                DataSet ds = null;

                strExcel = "select * from [Sheet1$]";

                myCommand = new OleDbDataAdapter(strExcel, strConn);

                ds = new DataSet();

                myCommand.Fill(ds, "table1");

                dgv.DataSource = ds.Tables[0];

            }