导入Excel表时,提示＂找不到可安装的ISAM＂

 用c#做导入Excel表时,提示＂找不到可安装的ISAM＂

 

我百度了下,发现可以如此处理:

 

1是在连接字符串里面加 HDR=NO;IMEX=1';

2是注册控件: Regsvr32 c:/WINDOWS/system32/msexcl40.dll

 

 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1';"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = "select * from [sheet1$]"; OleDbDataAdapter da = new OleDbDataAdapter(strExcel, strConn); DataSet ds = new DataSet(); try { da.Fill(ds); } catch (Exception ex) { throw new Exception("读取Excel失败："+ex.Message); } return ds;