基础类:
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];