string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=盐业—6.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";
OleDbConnection conn = new OleDbConnection(conStr);
OleDbDataAdapter da = new OleDbDataAdapter(@"select 帐务周期,电话号码,费用合计 FROM [Sheet1$]", conn); //where right(电话号码 , 4)='(小计)'
conn.Open();
DataSet ds = new DataSet();
da.Fill(ds);
// MessageBox.Show( ds.Tables [0].Rows .Count .ToString() ,"aaa");
conn.Close();
this.dataGridView1.DataSource = ds.Tables[0];
OleDbConnection conn = new OleDbConnection(conStr);
OleDbDataAdapter da = new OleDbDataAdapter(@"select 帐务周期,电话号码,费用合计 FROM [Sheet1$]", conn); //where right(电话号码 , 4)='(小计)'
conn.Open();
DataSet ds = new DataSet();
da.Fill(ds);
// MessageBox.Show( ds.Tables [0].Rows .Count .ToString() ,"aaa");
conn.Close();
this.dataGridView1.DataSource = ds.Tables[0];