利用委托操作Excel实例

基础类：

public delegate string strSQL();

public static DataSet ExcelImport(string xlsPath, strSQL sql)
{
    try
    {
         // 连接字符串
         string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=Yes;IMEX =1';" + "data source=" + xlsPath;
         DataSet ds = new DataSet();
         OleDbDataAdapter da = new OleDbDataAdapter(sql(), connStr);
         // 填充DataSet
         da.Fill(ds);
         return ds;
     }
     catch (Exception ex)
     {
         throw ex;
     }
}

调用方法：

DataTable dt = ExcelUtilities.ExcelImport(xlsPath, () => { return "SELECT * FROM [" + sheet + "$] WHERE Days <> null"; }).Tables[0];