在winfrom选择某个excel文件读取到DataGridView控件中

在b站找的视频，并按照视频做的项目，如有侵权联系本人进行删除。
原视频链接：https://www.bilibili.com/video/BV18e411p7Tr?from=search&seid=4377624564316774647
开发环境：Visual Studio 2019
1.需要在项目引用中引用Microsoft office object LIbrary方法
2.
3.在winform窗体中放入一个botton控件，datagridview，和combox控件
4.在botton的单击事件中进行操作

 DataTableCollection tableCollection;
        private void btnbrowse_Click(object sender, EventArgs e)
        {
            using (OpenFileDialog openFileDialog = new OpenFileDialog() { Filter = "Excel Workbook|*.xlsx" })
            {

                if (openFileDialog.ShowDialog() == DialogResult.OK)
                {
                    txtFile.Text = openFileDialog.FileName;
                    using (var stream = File.Open(openFileDialog.FileName, FileMode.Open, FileAccess.Read))
                    {
                        using (IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream))
                        {
                            DataSet result = reader.AsDataSet(new ExcelDataSetConfiguration()
                            {
                                ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true }
                            });
                            tableCollection = result.Tables;
                            cbosheet.Items.Clear();
                            foreach (DataTable table in tableCollection)
                            cbosheet.Items.Add(table.TableName);//添加到组合框。cbosheet为combox的id

                        }

                    }
                }
            }
        }

5.
6.

  private void cbosheet_SelectedIndexChanged(object sender, EventArgs e)
        {
           
            DataTable dt = tableCollection[cbosheet.SelectedItem.ToString()];
            dataGridView1.DataSource = dt;
        }