C# winform 将excel表格导入datagridView 的方式

最新推荐文章于 2023-08-29 18:13:23 发布

m0_51714289

最新推荐文章于 2023-08-29 18:13:23 发布

阅读量1.1k

点赞数 2

文章标签： microsoft excel c#

本文链接：https://blog.csdn.net/m0_51714289/article/details/128903259

版权

方式一：

private void button1_Click(object sender, EventArgs e)
  { 
    OpenFileDialog fd = new OpenFileDialog();//打开文件对话框，筛选excel表格
            fd.Filter = "表格|*.xls";//打开文件对话框筛选器
            string strPath;
            if (fd.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    strPath = fd.FileName;
                    textBox3.Text = strPath;

                    DataSet ds = ExcelToDS(strPath);
                    DataTable dt = ds.Tables[0];
                    dataGridView1.DataSource= dt;                                       
                }
                catch
                {
                    Console.WriteLine();
                }
            }
   }


 public DataSet ExcelToDS(string Path)
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            string strExcel = "";
            OleDbDataAdapter myCommand = null;
            DataSet ds = null;
            strExcel = "select * from [sheet1$]";
            myCommand = new OleDbDataAdapter(strExcel, strConn);
            ds = new DataSet();
            myCommand.Fill(ds, "table1");
            return ds;
        }

方式二：

 private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog fd = new OpenFileDialog();//打开文件对话框，筛选excel表格
            fd.Filter = "表格|*.xls";//打开文件对话框筛选器
            string strPath;
            if(fd.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    strPath = fd.FileName;
                    //String strCon = "provider=microsoft.ACE.OLEDB.12.0;data source=" + strPath + ";extended properties=excel 8.0";
                    String strCon = "provider=microsoft.jet.oledb.4.0;data source=" + strPath + ";extended properties=excel 8.0";

                    OleDbConnection Con = new OleDbConnection(strCon);//建立连接
                    string strsql = "select  *from [Sheet1$] ";
                    OleDbCommand cmd = new OleDbCommand(strsql, Con);//建立要执行的命令
                    OleDbDataAdapter da = new OleDbDataAdapter(cmd);//建立数据适配器
                    DataTable dt = new DataTable();
                    da.Fill(dt);// 把数据适配器中的数据读到DataTable中
                    dataGridView1.DataSource = dt;//指定数据源


                   

                }

                catch(Exception ex)
                {
                    MessageBox.Show(ex.Message);

                } 
               

            }