程序中去读EXCEL文档,以前一直参考《》这个连接语句或是方法。
但在这次开发中,再次引用时,即出现了异常:“Could not find installable ISAM”。奇怪!经过一番查阅资料和修改,Insus.NET把代码稍作修改一调整:程序又可以跑起来了...public static string ExcelConnectionString(string filePhysicalPath) { string connectionString = string.Empty; string fileExtension = filePhysicalPath.Substring(filePhysicalPath.LastIndexOf(".") + 1); switch (fileExtension) { case "xls": connectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"", filePhysicalPath); break; case "xlsx": connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=YES\"", filePhysicalPath); break; } return connectionString; }