Exemple #1
0
        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;
            }
        }