private void button5_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); //定义打开的默认文件夹位置 openFileDialog1.Filter = "Excel文件(*.xls,xlsx)|*.xls;*.xlsx"; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { edt.Rows.Clear(); ExcelHelpers excelHelpers = new ExcelHelpers(); edt = excelHelpers.ExcelToDataTableFormPath(true, openFileDialog1.FileName, 0); this.dataGridView2.DataSource = edt; } }