点击按钮，导入excel

最新推荐文章于 2020-10-14 18:27:43 发布

转载最新推荐文章于 2020-10-14 18:27:43 发布 · 612 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/alina-he/p/3873243.html

文章标签：

#c#

需为2003版本

private void button1_Click(object sender, EventArgs e)
        {
            string resultFile = "";
            OpenFileDialog openFileDialog1 = new OpenFileDialog();
            openFileDialog1.InitialDirectory = "D:";
            openFileDialog1.Filter = "All files (*.*)|*.*|xls files (*.txt)|*.xls";
            openFileDialog1.FilterIndex = 2;
            openFileDialog1.RestoreDirectory = true;
            openFileDialog1.Multiselect = true;

            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                resultFile = openFileDialog1.FileName;

            }
            if (resultFile == "")
            { }
            else
            {
                dt = FunctionExcel.ExcelToDataTable(resultFile, "Sheet1");

                dgv_Data.DataSource = dt;
            }
        }