Solution1://AM是excel sheet名，where后面的条件Priority是字段名,我这里是抽取Priority = 0的记录string query1 = " SELECT * FROM [AM$] where Priority = 0";//dataset for returnDataSet dataset = new DataSet();//fill datadataset.Tables.Add(readSheet(query1, path));附上readsheet方法:
public DataTable readSheet(string query,string path)
{
//open connection, this is the connection string for office 2007
string strCon = @"Provider = Microsoft.ACE.OLEDB.12.0 ; Data Source = " + path + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
OleDbConnection Conn = new OleDbConnection(strCon);
Conn.Open();
OleDbCommand cmd = new OleDbCommand(query, Conn);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
//dataset for return
DataTable dt = new DataTable();
//fill data
adapter.Fill(dt);
Conn.Close();
return dt;
}PS:path是excel路径，连接字符串是office2007的，03的你可以上网搜下Solution2:DataRow[] dr = dataset.Tables[0].Select("Priority = 0");for (int i = 0; i < dr.Length; i++){
dt.ImportRow(dr);}Also can use datatable.select("");
