Else's blog

string source = "D:\\book1.xls";//execel文件的完整路径
           string sqlconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1' ";
           string sql = "SELECT  * FROM [Sheet1$] where f1 is not null and  f2 is not null ";
           OleDbCommand oldcom = new OleDbCommand(sql, new OleDbConnection(sqlconn));
           OleDbDataAdapter oleda = new OleDbDataAdapter(oldcom);
           DataSet ds = new DataSet();
           oleda.Fill(ds, "[Sheet1$]");


           DataTable dtData = new DataTable();

           for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
           {
              
               dtData.Columns.Add(ds.Tables[0].Rows[0][i].ToString());//这里的名字就是自定义的

               dtData.Columns[i].DefaultValue = ""; //格式化
           }

           DataRow drData;

           for (int i = 1; i < ds.Tables[0].Rows.Count; i++)//过滤相同的值
           {




              
               if (ds.Tables[0].Rows[i][0].ToString() != ds.Tables[0].Rows[0][0].ToString())
               {

                   drData = dtData.NewRow();

                   for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
                   {
                       drData[j] = ds.Tables[0].Rows[i][j].ToString();

                   }
                   dtData.Rows.Add(drData);

               }

           }

          
           this.dataGridView1.DataSource = dtData;//绑定



           lb_count.Text = dataGridView1.Rows.Count.ToString();