DataSet ds = new DataSet();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
DataTable dt3 = new DataTable();
dt2.Columns.Add("工号");
dt2.Columns.Add("时间");
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; " + "Data Source ="
+ txtPath .Text + ";Extended Properties=Excel 8.0";
OleDbConnection myConn = new OleDbConnection(strCon);
string sql = "select * from [sheet1$A:B]";
int kk = 0;
try
{
myConn.Open();
OleDbDataAdapter oda = new OleDbDataAdapter(sql, myConn);
oda.Fill(ds, "[Sheet1$]");
myConn.Close();
dt1 = ds.Tables[0];
for (int i = 0; i < dt1.Rows.Count; i++)
{
DataRow dr = dt2.NewRow();
dt2.Rows.Add(dr);
dt2.Rows[i]["工号"] = dt1.Rows[i][0];
dt2.Rows[i]["时间"] = dt1.Rows[i][1];
}

DataRowCollection rows = dt2.Rows;

for (int j = 0; j < dt2.Rows.Count; j++)
{
if (Convert.ToInt32(dt2.Rows[j]["工号"]) == 1001)
{
rows[j].Delete();
}
}
dt2.AcceptChanges();
label1.Text = dt2.Rows.Count.ToString();
//label1.Text = kk.ToString();
this.dataGridView1.DataSource = dt2;
dataGridView1.Columns[1].Width = 200;
}
catch (Exception ex)
{

MessageBox.Show(ex.Message);
}

这是我得代码，不知道为什么结果就是和预期不一样

恩，待会该Npoi来读取试试