Excel导入DataSet

最新推荐文章于 2019-07-09 04:51:00 发布

hs123

最新推荐文章于 2019-07-09 04:51:00 发布

阅读量770

点赞数

分类专栏： C#.Net 文章标签： dataset excel string properties exception file

本文链接：https://blog.csdn.net/hs123/article/details/1599329

版权

C#.Net 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

OpenFileDialog openFileDialog1 = new OpenFileDialog();
           // this.SetStyle("Table");
            string file="";
            openFileDialog1.Filter = "Excel数据文件|*.xls";
            openFileDialog1.RestoreDirectory = true;
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                file = openFileDialog1.FileName;
                try
                {
                    string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file + ";" + "Extended Properties=Excel 8.0;";
                    OleDbConnection conn = new OleDbConnection(strConn);
                    conn.Open();
                    OleDbDataAdapter myCommand = null;
                    DataSet ds = null;
                    string strExcel = "select * from [" + "sheet1"+ "$]";
                    myCommand = new OleDbDataAdapter(strExcel, strConn);
                    ds = new DataSet();
                    myCommand.Fill(ds, "sheet1");
                    conn.Close();
                    dataGridView1.DataSource = ds.Tables[0];
                }
                catch (Exception loErr)
                {
                   MessageBox.Show(loErr.Message);
                }